Which data type can be used only on OUTPUT parameters of the
stored proceduer?
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
Stored Procedure.
4)A global cursor that can refrenced outside the procedure.
Is This Answer Correct ? | 4 Yes | 1 No |
What are number line correlation administrators will use while working with a subquery?
How can you set the threshold at which sql server will generate keysets asynchronously?
What is policy management?
Explain how many normalization forms?
How to get the definition of a trigger back?
What are the different ways of moving data/databases between servers and databases in SQL Server?
Explain about integration services of Microsoft SQL server?
How to assign null values to variables or columns?
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;"
Explain about extended stored procedure?
What type of locking occurs during the snapshot generation? : sql server replication
Some queries related to SQL