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
- 6707 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 the maximum size per database for sql server express?
How to search for a string in all stored procedure in sql server?
Is port 1433 secure?
How to send email from database?
How will you decide the active and passive nodes?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Do you know what is difference between index seek vs. Index scan?
Explain datetimeoffset data type in sal server 2008?
What is checkpoint process in the sql server?
Tell me what is the significance of null value and why should we avoid permitting null values?
Which is the main third-party tool used in sql server?
What are the different types of upgrades that can be performed in sql server?
-
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)
