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

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

Question Posted / jadhavsi

2 Answers
5379 Views
I also Faced
E-Mail Answers

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 split brain scenario in DB mirroring?

1 Answers

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

0 Answers

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers CMS, Impetus,

How to create new table with "create table" statements?

0 Answers

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers Value Labs,

Is a primary key unique?

0 Answers

what is dbcc? : Sql server database administration

0 Answers

What are rows and columns?

0 Answers

Explain comment on transactions?

0 Answers

Explain trigger and trigger types?

0 Answers

What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers

For more SQL Server Interview Questions Click Here