Monday, November 2, 2009

SQL Alt+F1 key


I was doing some ADHOC queries in SQL Server 2005 the other day and ran across something pretty neat. If you forget the parameters for a stored procedure like sp_colums, you can press ALT+F1 and receive a grid with information about that stored procedure including the parameters.

 

Same can be used for displaying the fields of a table too. Try it out. Very handy key combination

 

 

0 comments:

Post a Comment

Total Pageviews

Copyright © Tech & Management Notes