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
- 6600 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 are the new scripting capabilities of ssms? : sql server management studio
Rate yourself in .NET and SQL ?
1 Answers Cognizant, HCL, SunGard,
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What are the types of processing and explain each? : sql server analysis services, ssas
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Do you know query execution plan?
Explain indexed views?
What are extended events in sql server?
What is difference between drop truncate and delete?
How to use transact-sql statements to access the database engine?
Describe how to use linked server?
Which is better statement or preparedstatement?
-
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)
