How to receive returning result from a query?



How to receive returning result from a query?..

Answer / Ateequr Rehman

In MS SQL Server, you can use the OUTPUT clause to return the results of an INSERT, UPDATE, or DELETE statement. Alternatively, you can use stored procedures and output parameters.nnExample using OUTPUT:nINSERT INTO table_name (column1, column2) VALUES (@val1, @val2) OUTPUT INSERTED.ID

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Can we return Data from 4(more than 1) tables in stored procedure?

1 Answers   HCL,


Tell me what is fill factor?

1 Answers  


What is policy based management (pbm)? : sql server database administration

1 Answers  


What purpose does the model database server?

1 Answers  


What is the difference between IN and EXISTS operators in SQL Server?

9 Answers   ASD Lab, CSC, Intelligroup,


Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,


What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,


what is trigger . hw will it use them

2 Answers   TCS,


To find second largest salary in Employee table

17 Answers   CSS,


How to transfer Logins from SQL Server 2000 to 2005

2 Answers  


What is database architecture? : SQL Server Architecture

1 Answers  


Can we insert data into a view?

1 Answers  


Categories