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
Can we use pragma autonomous_transaction in trigger?
How do you run a trace?
What is the syntax to execute the sys.dm_db_missing_index_details?
What is the fastest way to permanently delete a 1 million row table named customers?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Different types of keys in SQL?
Differentiate between mongodb vs. Sql server?
Does partitioning improve performance sql server?
whats new about truncate in sql server 2008?
How connect excel to sql server?
How to verify a user name with sqlcmd tool?
Why use identity in sql server?
How many types of attribute relationships are there? : sql server analysis services, ssas
What is filter index?
Explain the microsoft sql server delete command? : SQL Server Architecture