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 |
Can we return Data from 4(more than 1) tables in stored procedure?
Tell me what is fill factor?
What is policy based management (pbm)? : sql server database administration
What purpose does the model database server?
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?
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.
what is trigger . hw will it use them
To find second largest salary in Employee table
How to transfer Logins from SQL Server 2000 to 2005
What is database architecture? : SQL Server Architecture
Can we insert data into a view?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)