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
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What is user-defined inline table-valued function?
Are connections to sql server encrypted?
Explain different types of self contained sub query?
How do you improve the performance of a SQL Azure Database?
What are rest-style architecture's?
What are the differences between triggers and stored procedures?
Does sql server 2016 have ssms?
What is transaction server consistency?
What are the differences between lost updates and uncommitted dependencies?
Explain log shipping and mention its advantages.
How the authentication mode can be changed?
What happens to a trigger with multiple affected rows?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is a transaction and why is it important?