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
William Buchanan
shared this idea
-
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