Interested to Buy Any Domain ? << Click Here >> for more details...
Which data type can be used only on OUTPUT parameters of the
stored proceduer?
- 2 Answers
- 6702 Views
- I also Faced
- E-Mail Answers
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
How can I add Reporting Services reports to my application?
Explain syntax for disabling triggers?
what is a check constraint?
What is bulkcopy in sql?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
How is foreign key related to primary key?
What is 2nf in normalization?
What is failover clustering overview?
Explain what is analysis service repository?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What are the different types of backups that exist?
What is an indice?
what is a deadlock? : Sql server database administration
What are the disadvantages of using the stored procedures?
