Competition: What’s your favorite Redgate tool? Enter now.

suggestion: double click object returns predefined query

austrianfoodispukeaustrianfoodispuke Posts: 100
edited June 9, 2008 12:50PM in SQL Prompt Previous Versions
In options have default code to fire

could be "sp_help object" or "select top 10 * from object"

and maybe even custom code

for table "bob" return "select top 10 * from bob where date > ..."


When the user double clicks on an object, the above code is fired.

Results could either go to normal window, balloon or other 'redgate' style pop-up


Alternatively, when the cache refresh runs, get it to execute "select top 10 *" from each table, then display this instead of/as well as the existing schema def pop up

Comments

Sign In or Register to comment.