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 the purpose of floor function?

0 Answers  

What is named calculation? : sql server analysis services, ssas

0 Answers  

What are views in ms sql server?

0 Answers  

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

What is the difference between char, varchar and nvarchar?

0 Answers  




What is the cartesian product of the table?

0 Answers  

What are the differences between char and nchar in ms sql server?

0 Answers  

How do I partition a table in sql server?

0 Answers  

Explain the collation?

0 Answers  

What happens if you delete a table that is used by a view?

0 Answers  

What is a not null constraint?

0 Answers  

What is the difference between delete and truncate statements?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories