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 is subquery? Explain the properties of a subquery?
How to update a field in SQL after ALTERING a row?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What do you understand by triggers and mention the different types of it?
What is report subscription?
What is page-level compression?
List few advantages of stored procedure.
What are the basic functions for master, msdb, model, tempdb databases?
How to change parameter value inside the report?
what is hash nonclustered index
What is model database? : SQL Server Architecture
What is sql server database?
What is the default value of an integer data type in sql server 2005?
How to drop existing views from a database in ms sql server?
Do you know what are various aggregate functions that are available?
