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 main differences between #temp tables and @table variables and which one is preferred?
What is an indexed view?
How to return the second 5 rows in ms sql server?
What are sub reports?
How is sql used in sql server?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What is 'write-ahead log' in sql server 2000 ?
Where to find ntwdblib.dll version 2000.80.194.0?
What are the restrictions that views have to follow?
What is the difference RDBMS and Graph Database?
What is the difference between a primary key and a unique key? Are they the same?
What is function of CUBE ?
Explain alternate key, candidate key and composite key in sql server?
What are the advantages of having an index on the sql server?
Explain some stored procedure creating best practices or guidelines?