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
- 6721 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
What is difference between index seek vs. Index scan?
What is enhanced database mirroring in sql server 2008?
How to find the login name linked to a given user name?
Mention the command used to rename the database.
How to create user defined functions with parameters?
What is difference between cte and view?
What is forward - only cursors / read only cursor?
What is the difference in accessing db between sql server vs sql azure?
How to use order by with union operators in ms sql server?
What is raid, and how it can influence database performance?
How can I create a report based on a query? : sql server management studio
Can we write ddl in trigger?
Why do you want to join software field as you have done your BE in Electronics?
How to connect php with different port numbers?
Can sql servers linked to other servers like oracle?
