Software Developer, Equity Analyst, Polymath.
Posts tagged sql select top records
SQL 2008 – Change “Edit Top 200 Rows”
314 years
by Ray Tawil
in MS Sql Server
Well this is a great idea from Microsoft, but what if you want them all , or you want more then 200 rows like me
, I am greedy
, I like everything….
Any ways I was prepared to hack the registry for this one , but it seems you don’t really have to
, and its in very simple to do and find…
Lesson 1 learned, late nights and SQL don’t mix.
Lesson 2 Change the Top 200 rows
go to:
Tools -> Options ->SQL Server Object Explorer, Expand this tree
Choose ‘Commands’
And there you go change it to your desired amount, 0 = everything!
This is the youtube link for my demonstration :
Best Regards.
Rabih Tawil