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
Give an example of why you would want to denormalize a database
What is a database in ms sql server?
What is checkpoint in sql server?
What is table-valued sub query?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
Explain the use of keyword with encryption. Create a store procedure with encryption?
How do you start single user mode in clustered installations?
What are differences in between sql server 2012 and sql server 2016?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is the difference between the 2 operating modes of database mirroring?
How to specify the collation for a character data type in ms sql server?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
Is mysql the same as sql server?
What is a system database and what is a user database?
How to get the query of a table in sql server?