One of my coworkers is running a stored proc from the SQL Server Management Studio (2005), by right clicking on it and selecting Execute Stored Procedure. The resulting query comes up like this:
She doesn't want to see the return value in the result, and doesn't want to comment out the [tt]SELECT 'Return Value' = @return_value[/tt] statement either. Is there some sort of setting somewhere that will tell the interactive execution process to suppress showing this value? (I kind of doubt it because it's best practice, but I said I'd research it.)
TIA
An unforeseen consequence of the information revolution has been the exponential propagation of human error.
Code:
USE [MYDB]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[BobTest1]
@StartDate = N'20110101',
@EndDate = N'20110401'
SELECT 'Return Value' = @return_value
GO
TIA
An unforeseen consequence of the information revolution has been the exponential propagation of human error.