You recently published a script showing how to do pagination (e.g. results 20 - 30 of 100) It's also possible to do it quicker and more elegantly without having to resort to building the sql string dynamically (never a good thing IMHO). You pass in 2 parameters, @PageIndex is the first record you want (so […]
2006-05-31 (first published: 2006-05-24)
1,255 reads
By Arun Sirpal
You can read about all the new role based qualifications from Microsoft here –...
By Steve Jones
It’s the eve of the Fourth of July, when the Declaration of Independence is...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
I need to write a query which will first update the table, then execute...
To shorten a long story, my organisation has decided to have a vendor...
Hi everyone, W are just doing a migration from sql 2012 enterprise to sql...
Ask SSC