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
- 6599 Views
- I also Faced
- E-Mail Answers
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 is a field in a table?
Can you explain various data region available in ssrs with their use?
What are the elements of dbms?
How to rebuild indexes with alter index ... Rebuild?
How to create dbo table in sql server?
Define master database?
What options are available to audit login activity? : sql server security
Which sql server table is used to hold the stored procedure scripts?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What do you understand by triggers?
How does stuff differ from the replace function?
Can a rule be bound to any column of any data type?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
