Which data type can be used only on OUTPUT parameters of the
stored proceduer?
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 happens on checkpoint?
How can we call UDF(User Define Function) using C# code in ASP.net ?
How do you delete a data source?
Do you know sql server 2008 introduces automatic auditing?
Tell me extended events in sql server 2008?
Can an automatic recovery be initiated by a user?
What are different types of join?
How to defragment table indexes?
Explain what is the function of sql server agent windows service?
How many types of attribute relationships are there? : sql server analysis services, ssas
Do you know data definition language, data control language and data manipulation language?
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 use of commit?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
Explain what is lock escalation?