Suppress the results of a stored procedure

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.


Calling a web service from SQL
Case sensitive SQL queries
Connection String Example
Copy ANY TABLE from one database to another
Create (and restore a database to) a TEST server for app testing
Creating a date calendar table
Find table and field a particular value reside
Find tables that have no permissions granted, and fix them
Get a person's age from their birthdate
Get the text of all the triggers in a database
Group by Grouping Sets example
How to format T-SQL
Insert an image into a SQL table from SQL
Log the user that changed a field
Loop through a string and show ASCII characters
Paging query contest
Parsing @tags from a SQL text field
Query that adds a blank like to the result set if the original resultset has more than one line
Remove unwanted characters from a field in SQL
sp_send_dbmail example
SQL code to resequence a grid
SQL Trigger Nest Level
Strip leading zeros
Suppress the results of a stored procedure
Table Value Constructors

CREATE PROCEDURE return_1 AS

SET NOCOUNT ON;

SELECT 1

GO

CREATE PROCEDURE call_return_1_and_return_2 AS

SET NOCOUNT ON;

DECLARE @Result TABLE (res int)

insert into @Result EXEC return_1

SELECT 2

GO

RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.

Links
Home
Knowledge Areas
Sitemap

Contact

Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences

Related Articles