Which data type can be used only on OUTPUT parameters of the
Answers were Sorted based on User's Feedback
Answer / 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
4)A global cursor that can refrenced outside the procedure.
|Is This Answer Correct ?||4 Yes||1 No|
Answer / jothi
|Is This Answer Correct ?||1 Yes||1 No|
Explain about system stored procedure?
What are the properties of the transaction?
Explain a differential backup?
What is temporal data type?
Difference between report and query parameter. Why do we need different type of parameter?
What is coalesce in sql server?
Differences between functions and stored procedures?
What is wrong with sql server client libarary dll, ntwdblib.dll?
How to recreate an existing index in ms sql server?
How do I start sql server agent automatically?
What are the benefits and tasks of object explorer? : sql server management studio
What is lock escalation?