DECLARE @del_table TABLE (emp_no INT, emp_lname CHAR(20));
DELETE employee
OUTPUT DELETED.emp_no, DELETED.emp_lname INTO @del_table
WHERE emp_no > 15000;
SELECT * FROM @del_table
All blogs consists of Asp.Net, C#, MVC 4.0, WCF, AJAX, JQuery, SQL Server, Infregestic Controls, Entity FrameWork, LINQ, JSON, Crystal Report, Angular etc.
DECLARE @name VARCHAR ( 50 ) -- database name DECLARE @path VARCHAR ( 256 ) -- path for backup files DECLARE @fileName ...
No comments:
Post a Comment