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
- 6730 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 do you understand by change data capture?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What do you understand by replication in sql server? Mention the different types of replication in sql server.
How to implement service broker?
What is a group function explain with an example?
what are candidate key, alternate key and composite key? : Sql server database administration
What is the main purpose of having conversation group?
What is store procedure?
how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.
Explain how to maintain a fill factor in existing indexes?
What are the two authentication modes in sql server?
What is cursor ? And what is difference between Trigger ?
-
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)
