1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / jadhavsi

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 Dependency Injection and provide example?

0 Answers  

How to transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

How to defragment table indexes?

0 Answers  

What is the use of keyword with encryption.

0 Answers  

How can I get data from a database on another server?

0 Answers  




How to include text values in sql statements?

0 Answers  

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

What stored by the tempdb ? : sql server database administration

0 Answers  

What are database states in ms sql server?

0 Answers  

What is blocking and how would you troubleshoot it?

2 Answers  

Comment,Datatypes are unlimited

0 Answers   IBM,

How to integrate the ssrs reports in application?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories