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
- 6621 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 difference between row_number and dense_rank?
How to store pdf file in sql server?
1 Answers CarrizalSoft Technologies, College School Exams Tests, TATA,
Can anybody explain me cold backup and hot backup?
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
How to insert data with null values?
Explain indexed views and partitioned view with their syntax.
How to delete the duplicate rows from a table in SQL Server ??
What is SQL Profiler and the use of it?
Is sql different from sql server?
How can I create a report based on a query? : sql server management studio
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
-
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)
