16 Kicks

Paging in SQL Server 2000 and 2005 ...(vadivel.blogspot.com)

submitted by vmvadivelvmvadivel(195) 5 years ago

In this article I have discussed in detail about the easier way of paging records using SQL Server 2005. In the due course I have introduced the nuances of using TOP keyword and the cool enhancements added to it. Along with that I would show you how to use TOP command to do paging in SQL Server 2000, albeit at a performance loss, then show how the same result can be achieved with higher performance thanks to new features in SQL Server 2005.

add a comment |category: |Views: 60

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
vmvadivelvmvadivel(195) - jhol3990jhol3990(495) - up2jjup2jj(0) - ashithmrashithmr(90)
More who kicked this story...
Comments:

No comments so far

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?