Deleted logical Table::
The Deleted table holds the recently deleted or updated values means old data values.
Hence old updated and deleted records are inserted into the Deleted table.
The Deleted table holds the recently deleted or updated values means old data values.
Hence old updated and deleted records are inserted into the Deleted table.
Example::
Suppose we have emp_info . Now We need to create two triggers to see data with in logical tables
Inserted and Deleted.
Suppose we have emp_info . Now We need to create two triggers to see data with in logical tables
Inserted and Deleted.
Step 1::Create Table
create table emp_info (empno int,ename varchar(100),manage_id int)
Step 2 ::CREATE TRIGGER on emp_info
CREATE TRIGGER trg_Emp_Ins
ON emp_info
FOR UPDATE
AS
begin
SELECT * FROM INSERTED -- show data in Inserted logical table
SELECT * FROM DELETED -- show data in Deleted logical table
end
Step 3::Now Update a record in emp_info table to see data with in deleted logical table.
update emp_info set ename='Sandip Gaikwad', manage_id=3 where empno=3
SELECT * FROM emp_info
Step 4::OUTPUT
Other Popular Posts ::
send sql table data via email using store procedure
How to use Store Procedure inside a store procedure
SET ANSI_NULLS in sql server
SET QUOTED_IDENTIFIER in sql
example of Cursor in sql server
basic of Cursor in sql.
delete duplicate records in sql server
select duplicate records in sql server
update duplicate records in sql server
comman table expression(CTE) in sql server
Split Funtions in sql server
Sql queries for sql server
Trigger on Update
Trigger on insert
trigger on delete
basic of trigger
insert into view with multiple tables
Insert into View in sql server
Interview queries in sql server
How to use Store Procedure inside a store procedure
SET ANSI_NULLS in sql server
SET QUOTED_IDENTIFIER in sql
example of Cursor in sql server
basic of Cursor in sql.
delete duplicate records in sql server
select duplicate records in sql server
update duplicate records in sql server
comman table expression(CTE) in sql server
Split Funtions in sql server
Sql queries for sql server
Trigger on Update
Trigger on insert
trigger on delete
basic of trigger
insert into view with multiple tables
Insert into View in sql server
Interview queries in sql server
No comments:
Post a Comment
if you have any doubt any suggestions do comment