Can we passed multiple recordset(set of records) using a
Stored Procedure
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of locks in the database?
What is an inner join?
Explain left outer join and right outer join?
How can we delete Duplicate row in table?
What is inline variable assignment?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is the impact on other user sessions when creating indexes?
Please explain go command in sql server?
How data can be copied from one table to another table?
Which is the main third-party tool used in sql server?
Can binary strings be used in arithmetical operations?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
How to how to convert numeric expression data types using the convert() function??
List the various tools available for performance tuning?
What is the Main Difference between ACCESS and SQL SERVER?