Interested to Buy Any Domain ? << Click Here >> for more details...
Can we passed multiple recordset(set of records) using a
Stored Procedure
- 2 Answers
- 5524 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anil
just write DML sttements like insert into table1 values(),insert into table2 values()in stored procedure.By the way you can send multiple records at one time.
| Is This Answer Correct ? | 1 Yes | 0 No |
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
how to generate XML out of QUERY?
How to connect ms access to sql servers through odbc?
What is normalization? What number of normalization shapes are there?
What is a constant or literal in ms sql server?
Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)
Does hive support indexing?
what is differencial backup?how to work?Anybody explai it?
Can a database be shrunk with users active?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What does select 1 mean?
What is the exact numeric data type in sql?
-
Oracle (3253) - 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)
