how To Make Triger Like when Table Record > 10 Then Delete and Cancel inserting Data in Table

23 Feb 2010 01:02:51

Hi I want to Create One Triger That like when Table Records Greater then 10 then Delete or Canceling the inserting Records Regards Kirti Darji

Kirti.Darji.001

Expert Boarder

Posts: 28

From 03-Jun-2009

You're Points: 538

Re:how To Make Triger Like when Table Record > 10 Then Delete and Cancel inserting Data in Table

23 Feb 2010 01:02:51

Hi Yes to this you need use the INSTEAD of trigger. [color=#0000FF]Create Trigger trgInsteadDelete On TableName INSTEAD OF DELETE AS BEGIN DELETE FROM TableName WHERE TableName.CoulmnName>10 END[/color] Here great article to learn about to triggers [url]http://www.sql-server-performance.com/articles/dev/triggers_2000_p5.aspx[/url] Thank you

RRaveen

Gold Boarder

Posts: 156

From 03-Jun-2009

You're Points: 1106

^ Scroll to Top