Interested to Buy Any Domain ? << Click Here >> for more details...
Which data type can be used only on OUTPUT parameters of the
stored proceduer?
- 2 Answers
- 6694 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhusudan singh kushwah
Stored procedure return data In 4 ways. which are as follow:
1)output Prameter:-which can return either data(such As
integer or char value) or a cursor variable(cursors are
result sets that can be retreived 1 row at a time).
2)return Codes:-Which are always an Integer Value.
3)A result set for each statement contain in Stored
procedure or any other Stored procedures called by the
Stored Procedure.
4)A global cursor that can refrenced outside the procedure.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is ms sql server service broker?
What is coalesce and check constraint in sql server?
What is a raid and what are different types of raid configurations?
What is a transactions?
Define union, union all, minus, intersect?
What is the difference between count () and rowcount ()?
How to list all objects in a given schema?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Explain what is log shipping?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What is ms sql server triggers?
what are the three command line utilities and what are their primary functions?
How do I find information about the install locations for the various instances running on a computer?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
