Tech Support: Select Edit All Records In SQL Server 2008

Select Edit All Records In SQL Server 2008

In SQL Server 2008, the default numbers of rows for selecting and editing records are 1000 and 200 respectively. Sometimes if the records are greater than 200 and you want to edit some record then you have to change the query to get all the records. This is time consuming and you have to repeat this exercise whenever the records are greater than 200. The solution for getting all the records for selecting and editing is given below in steps:

1- Open SQL Server 2008 Management Studio
2- Goto Tools
3- Click "Options"
4- Expand the tree of "SQL Server Object Explorer"
5- Click "Commands"
6- Change "Value for edit top < n > rows command" to 0
7- Change "Value for select top < n > rows command" to 0
8- Click "OK"

Jun 29, 2012 | 0 comments | Labels: SQL, Tips and Tricks

Tech Support

Select Edit All Records In SQL Server 2008

0 comments:

Post a Comment

GOOGLE+

Get Free eMail

Free eMail Support

Scrolling News

My Favorite Blog List

Labels

Pincode Search

Useful Websites

Facebook Friends

DISCLAIMER

Google Tamil Literation

Archive

x