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 |
how to select 5 to 7 rows from a table, which contains 10 rows?
What is instead of trigger sql server?
Why do we use non clustered index?
What are unicode character string data types in ms sql server?
What are scalar functions?
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?
Explain the storage models of OLAP?
How to create a dml trigger using create trigger statements?
what is Equity join?
What are the properties of the relational tables?
What the different components of Replication and what is their use?
What is the default fill factor value?
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)