DavidM
4Penny.net
Points: 7450

6/23/2021 8:34:32 AM

Handy SQL SSMS hack

Ok. Pay attention. You'll thank me later. 

I spend my day writing SQL, working in SSMS. 

Often, when writing stored procedures, I'll execute the script (creating the object) and then scroll to the top of the page and execute the sproc using a piece of test code that will call the sproc. 

Scroll up, scroll down. Repeat. 

Or, you copy the test code throughout your code. Messy. 

How about this?

4Penny.net
Version: Unknown or N/A
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3