സ്ത്രീകള്‍ എങ്ങിനെ വസ്ത്രം ധരിക്കണം എന്ന് പുരുഷന്‍ നിഷ്ക്കര്‍ഷിക്കുന്നത് ശരിയോ? അല്ലെങ്കില്‍ തിരിച്ചും?

Saturday, June 30, 2012

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"


No comments:

Post a Comment

Hmmmmm... what are you thinking? Do not forget to comment,It helps us to improve this blog and help us to make better. on