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
Explain transaction server distributed transaction?
What are triggers? How do you invoke a trigger on demand?
How can you stop stored procedures from recompiling?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How do I manually uninstall an instance of sql server 2016?
What are the parts of a function?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What happens if you are trying to access a schema not owned by you?
When columns are added to existing tables, what do they initially contain?
Can we call future method from trigger?
what do you understand by change data capture?
What is clustered index
How to create a stored procedure with a statement block in ms sql server?
What is explicit cursors?
What is difference between foreign key and unique key?