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
- 6812 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 are unicode character string data types in ms sql server?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
How much does sql server 2016 cost?
Explain syntax for dropping triggers?
What is use of dbcc commands?
How to retrieve field values using mssql_result()?
How to create user messages with print statements in ms sql server?
What do you mean by table and field in sql?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is trace flag in sql server?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
How to create indexed view?
Can we add a cpu to sql server?
What is normalization? What number of normalization shapes are there?
Differentiate sql server reporting services vs. Crystal reports?
