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 specify the collation for a character data type in ms sql server?
What is a join in sql?
What are the restrictions applicable while creating views? : SQL Server Architecture
What do you mean by SQL injection attack?
How to define and use table alias names in ms sql server?
What is key set driven?
Can a table have 2 foreign keys?
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
What do you mean by acid?
What is a subquery in a select query statement in ms sql server?
Explain few examples of RDBMS?
What is difference between joins and subqueries?
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)