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).
William Buchanan
shared this idea
-
Eros Olmi
commented
Thanks for this feature. We have many tables of millions of records each and I didn't found an option to just load few records. Now I got it.
A little thing to change: use the new SQL to indicate TOP records.
At the moment it adds ... TOP X ... but should add TOP (X)https://docs.devart.com/studio-for-sql-server/writing-and-executing-sql-statements/df199.html
Maybe nice to have indicated in help too in this topic.
https://docs.devart.com/studio-for-sql-server/user-interface-concepts/manage-tables-from-database-explorer.htmlThanks a lot.
Eros -
AdminDevart
(_, Devart)
commented
Hi,
Thanks for your patience!
Just want to inform you that the option "Database Explorer > General > Preferred Selection Size > Top n Rows" has been implemented.
So we would like to suggest updating to the latest version and check there.
Best,
Devart Support Team
-
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