Joel
4Penny.net
Points: 10550

4/28/2017 4:16:44 PM

Suppress the results of a stored procedure

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

Today I need to call an existing stored procedure that inserts a line into a table. This proc always returns the RowID of the inserted line. 

In the place where I'm calling it I can't have that result set, so I need to suppress it. 

Had to search to find the answer, I'll blog it here so I don't lose it again. 

 

4Penny.net
Version: All
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