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
What are the types of processing and explain each? : sql server analysis services, ssas
What type of locking occurs during the snapshot generation? : sql server replication
what is the system function to get current user's user id? : Sql server database administration
What is local temp table?
How to backup SQL Server Reporting Services ?
List out the differences between global and local temp tables in sql server?
What is extent? Types of extents?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Explain system rowset functions?
How can we solve concurrency problems?
How do you open a cluster administrator?
What is the difference between an index and a unique index?
Can a function call a stored procedure in sql server?
What is a user-defined function in the sql server and what is its advantage?
Can we insert data if clustered index is disabled?