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 |
Explain the concepts and capabilities of sql server?
What is raiseerror? What is raiseerror?
What is difference between clustered index and non clustered index?
Can you tell me about the concept of ER diagrams?
Do you know what are various aggregate functions that are available?
What is db stored procedure?
What is blocking and how would you troubleshoot it? : sql server database administration
What are system databases into sql server (2005/2008)?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
between cast and convert which function would you prefer and why?
What are the types of user defined functions in sql server?
How to store and query spatial data?
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)