Edit Top 200 Rows – MS SQL Server 2008

Have you ever felt the following options in MS SQL Server 2008 :

Edit top 200 Rows

Select Top 1000 Rows

Are many a times hurdle for you or you wanted “Edit All and Select All features” ?

This particular number 200 as well as 1000 is a configurable one.

Go to Tool -> Options -> SQL Server Object Explorer -> Under ‘Table and View Options’ ->Value for edit top <n> Rows Command

Here change this value to whatever you desire. Change it to zero , and you would get ‘Select All’ and ‘Edit All’ Feature !

Edit Top 200 Rows

Edit Top 200 Rows / Select Top 1000 Rows

 

 

Advertisements

About mytechlifedays

Its been a wonderful learning period over the last 6 years in the IT industry , getting exposed to whole lot of technologies and ideas. The hurdles and the crisis that came along have been wonderful experience ... And now its time to pen them down so that let some others execute faster and easily with these information .....
This entry was posted in Database and tagged . Bookmark the permalink.

Leave a Reply ! It would be always appreciated ! :)

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s