Can we passed multiple recordset(set of records) using a
Stored Procedure

Answers were Sorted based on User's Feedback



Can we passed multiple recordset(set of records) using a Stored Procedure..

Answer / trishit kumar bera

Use Xml data type

Is This Answer Correct ?    9 Yes 2 No

Can we passed multiple recordset(set of records) using a Stored Procedure..

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

Post New Answer

More SQL Server Interview Questions

What is de-normalization and when do you do it?

3 Answers  


Can you explain what is sql server english query?

0 Answers  


What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,


Why use triggers?

0 Answers  


What is indexed views? plz explain with example?

2 Answers  






how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,


How to use user defined functions in expressions?

0 Answers  


What are the events recorded in a transaction log?

0 Answers  


what protocol both networks use? : Sql server database administration

0 Answers  


Define normalisation?

0 Answers  


1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

2 Answers  


How to filter out duplications in the returning rows in ms sql server?

0 Answers  


Categories