How To: Paging Large Datasets in SQL Server
-
all in the head — Paging Large Datasets in SQL Server
One really nifty feature of SQL Server (and I wish MySQL would support this more fully) is native XML output. You can basically take any query and put FOR XML on the end, and instead of a recordset object, it returns an XML document.
Leave a Reply
Spread The Word...
Every time you don't...god kills a kitten. Think about the kittens.
![[del.icio.us]](http://www.rossboardman.com/wp-content/plugins/bookmarkify/delicious.png)
![[Digg]](http://www.rossboardman.com/wp-content/plugins/bookmarkify/digg.png)
![[Facebook]](http://www.rossboardman.com/wp-content/plugins/bookmarkify/facebook.png)
![[MySpace]](http://www.rossboardman.com/wp-content/plugins/bookmarkify/myspace.png)
![[StumbleUpon]](http://www.rossboardman.com/wp-content/plugins/bookmarkify/stumbleupon.png)
![[Technorati]](http://www.rossboardman.com/wp-content/plugins/bookmarkify/technorati.png)
![[Twitter]](http://www.rossboardman.com/wp-content/plugins/bookmarkify/twitter.png)
