SQL SERVER 2005 , How to Partition the table.
All we know SQL Server 2005 has new features are going to discuss in this article is the Row Number function and Partitioning.
Normally developers used temporary tables and co-related sub-queries to generate calculated row numbers in a query. Now SQL Server 2005 provides a function, which replaces all of the additional resources we used to generate row numbers……… http://blog.joggee.com/?p=17
Normally developers used temporary tables and co-related sub-queries to generate calculated row numbers in a query. Now SQL Server 2005 provides a function, which replaces all of the additional resources we used to generate row numbers……… http://blog.joggee.com/?p=17
Comments
Feel free to leave a comment...
and oh, if you want a pic to show with your comment, go get a gravatar!
