Answer Posted / swetha
Using PRINT command in stored procedure.
use print to check if the parameter values are fine.
When the stored procedure is executed then print will show
the output of those parameters/variables.
| Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
Can select statements be used on views in ms sql server?
What is bit data type? What's the information that can be stored inside a bit column?
What is sharding?
Is it ok to shrink transaction log?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
How can sql server instances be hidden? : sql server security
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
List out the differences between global and local temp tables in sql server?
Explain trigger and its types?
How to execute a sql statement using mssql_query()?
What are window functions in sql server?
Do you know what are acid properties of transaction?
How to enter binary string literals in ms sql server?
How to execute function in stored procedure sql server?
How to create a dml trigger using create trigger statements?