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 |
Difference between rowid and rownum in SQL?
Explain tablesample?
How to enter unicode character string literals in ms sql server?
What are the system database in sql server 2005?
Get Current System Date Time
how do we insert 100 records at a time in a table without using for loop in database
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
How to call a function from a stored procedure in SQL Server ?
Why would you use sql agent?
How to list all dsn entries on your local machine using odbc_data_source()?
what is isolation level at dead lock?
Explain datetime2 data type in sal server 2008?
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)