Can we passed multiple recordset(set of records) using a
Stored Procedure
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 |
What is split brain scenario in DB mirroring?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What are the advantages of using sql server over ms access or why should one use sql instead of ms access
How to create new table with "create table" statements?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Is a primary key unique?
what is dbcc? : Sql server database administration
What are rows and columns?
Explain comment on transactions?
Explain trigger and trigger types?
What is mscorsvw.exe - process - microsoft .net framework ngen?
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)