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
- 6595 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
Explain external key management in sql server 2008
what is database replicaion? : Sql server database administration
What are basics of policy management?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Do you know clustered and non-clustered index?
What is default constraint?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
How to integrate the ssrs reports in application?
What are the tables in sql?
What are the database roles? : sql server security
What is conditional split?
What is a primary key?
Why olap is used?
What is transaction server distributed transaction?
What are the types of user defined functions in sql server?
