About Me

My photo
MCTS FOR SQL SERVER 2008 DOT NET PROGRAMMING WEB DESIGNING

Tuesday, 18 October 2011

SIMPLE SYNTAX TO CREATE TRIGGER IN SQL

here i'l show how simple is creating a trigger in sql.....

SYNTAX:-

create trigger delete_trigger on itemlist
after update
as
begin
select * from deleted
end


Note:-- U must have itemlist table before using this code

No comments:

Post a Comment