开发者

Changing default settings in SQL Server Enterprise

开发者 https://www.devze.com 2022-12-24 20:33 出处:网络
In Microsoft SQL 2008 Enterprise manager, when you right click a table to open it the option only grabs the first 1000 rows. Same thing with an edit except it limits the result to 200 rows. Is there a

In Microsoft SQL 2008 Enterprise manager, when you right click a table to open it the option only grabs the first 1000 rows. Same thing with an edit except it limits the result to 200 rows. Is there a way to increase this in the context menu? I know I change the SQL once it loads, but I'd like to set the default value myself so I don't have to a开发者_JAVA技巧lways have to remove the TOP 1000 syntax from the query.


It can be found under

Tools->Options->SQL Server Object Explorer.

Look for

Value for Edit Top < n > Rows command

and

Value for Select Top < n > Rows command

0

精彩评论

暂无评论...
验证码 换一张
取 消