What are the challenges you face when working across database platforms? Take the survey

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


Sign In or Register to comment.