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 three different part of rdl file explain them?
What is the use of commit?
What is join query?
What is the log shipping?
what stored procedure would you use to view lock information? : Sql server administration
Write a SQL query to delete a table?
Can sub report data source be different from that of the parent report?
How do you create an execution plan?
What is a trace frag? Where do we use it?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What are date and time data types in ms sql server?
Can we hide the definition of a stored procedure from a use?
What is multilevel indexing?
What is an example of a primary key?