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

What are number line correlation administrators will use while working with a subquery?

0 Answers  


How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  


What is policy management?

0 Answers  


Explain how many normalization forms?

0 Answers  


How to get the definition of a trigger back?

0 Answers  






What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,


Explain about integration services of Microsoft SQL server?

0 Answers  


How to assign null values to variables or columns?

0 Answers  


1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  


Explain about extended stored procedure?

0 Answers  


What type of locking occurs during the snapshot generation? : sql server replication

0 Answers  


Some queries related to SQL

0 Answers   Motorola,


Categories