In SQL Server 2008 Object Explorer provides a inbuilt option to retrieve Top number of records, also There is an another provision to edit Top records.
By Default, the value will be 1000 for selection and 200 for Edit.
Have a look at the Exhibit.
By Default, the
Have a look at the Exhibit.
Some times, if you want to select very less number of records, you need to write the query with Top Keyword.
Here is a provision to customize this value by following ways.
Go to Tools Menu Select Options…
In Options Window, Select SQL Server Object Explorer, Commands
Here you can change the values as you likes. I changed 5 for Edit and 100 for select.
After updated the values, it will looks like
Hope it helps you!
No comments:
Post a Comment