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
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
what is raid? : Sql server database administration
what are the different types of SSRS reports?
What is a filestream?
What is the difference between primary key and unique constraints?
What are the advantages of log shipping?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What are sql azure firewall rules?
What are key constraints?
Describe in brief databases and sql server databases architecture.
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is the difference between function and stored procedure in sql server?
What do you need to connect php to sql server?
What is the recovery model? List the types of recovery model available in sql server?
Is it ok to shrink transaction log?
