Trigers

CREATE TRIGGER allaction ON tablename
FOR INSERT , DELETE ,UPDATE
AS
PRINT 'Inserted'
SELECT title, type, price FROM inserted
PRINT 'Deleted'
SELECT titleid, type, price FROM deleted

Sunny Bansal Detail

Hi Friends

I am Sunny Bansal from Shahabd Markanda Distt Kurukshetra Haryana. i am working as a .Net Trainer & Developer at ThinkNEXT Technologies Pvt. Ltd. Mohali Punjab from 2nd Jan 2012. I have three years experience in same domain. I know C, C++, .Net, Core Java, Core PHP, SQL Server 2005-2008

Copy & Paste below mention link to see my website created by me...

http://www.sunstarsolutions.somee.com