Retrieve Data select top n rows
Would you be able to change the 'Retrieve Data' context menu so that rather than doing a 'select * from table' it does a 'select top n from table' (where 'n' is a number I can configure).
I like having the retrieve data menu, but I avoid using it because with some tables it can lock up the system due to it selecting all rows (which can be millions of rows).
11
votes

-
Sebastián Golbert commented
Hi,
I have the same problem. The pagination mode doesn't work as expected, I must edit the SQL query in order to preview big tables. This is done correctly in other inferior products like SSMS.
Regards,
Sebastian