Tags » Cursors

SAO Windows 7 Theme v1

Theme Name: SAO Windows 7 Theme v1

Size: 62 MB

Wallpapers Resolution: UltraHD 3840×2160 at 300 dpi(pixels depth)


Wallpapers: 20

Sounds: Yes

Mouse Cursor: Yes… 39 more words


Everything in its Right Place - Database Normalisation

Flat File Tables – Everything at Once

I’m currently working on a project to replace an Excel based filesystem with a .NET / SQL Server solution. 794 more words


Drop and Create all Foreign Keys The Elegant Way

Yesterday I posted a script that will drop all of the foreign keys in your database in a very inelegant, but super effective way. Today’s script is slightly more sophisticated in that you can print out the CREATE statements for the foreign keys before running the drop. 934 more words



SQL Cursors


A cursor is nothing more than a pointer to a row that will loop through each row in a table, if there are a number of commands and checks to do within that query it will process these each time on each row, so, if there are 600,000 rows then this would take a long time! 170 more words

Troubleshoot And Optimise

vi Editor Commands.

Got a chance to work on server? Don’t worry that you should work in a black screen(even i thought the same).

Got a solution… Learning Vi editor. 321 more words