Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Which data type can be used only on OUTPUT parameters of the
stored proceduer?

Answers were Sorted based on User's Feedback



Which data type can be used only on OUTPUT parameters of the stored proceduer?..

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
Stored Procedure.

4)A global cursor that can refrenced outside the procedure.

Is This Answer Correct ?    4 Yes 1 No

Which data type can be used only on OUTPUT parameters of the stored proceduer?..

Answer / jothi

Cursor

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Explain about system stored procedure?

0 Answers  


What are the properties of the transaction?

0 Answers  


Explain a differential backup?

0 Answers  


What is temporal data type?

0 Answers  


Difference between report and query parameter. Why do we need different type of parameter?

0 Answers  






What is coalesce in sql server?

0 Answers  


Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,


What is wrong with sql server client libarary dll, ntwdblib.dll?

0 Answers  


How to recreate an existing index in ms sql server?

0 Answers  


How do I start sql server agent automatically?

0 Answers  


What are the benefits and tasks of object explorer? : sql server management studio

0 Answers  


What is lock escalation?

1 Answers  






Categories