jayakrishnan Morayur

jayakrishnan Morayur

  • NA
  • 193
  • 258.3k

Create script of trigger

Mar 10 2011 6:08 AM
i want generate script trigger as bellow

i want generate script trigger as bellow

IF
NOT EXISTS (SELECT * FROM sys.triggers WHEREobject_id = OBJECT_ID(N'[dbo].[TriStockadjustmentDelete]'))EXEC
CREATE TRIGGER [dbo].[Sample]
ON [dbo].[customerTable]
AFTER delete
AS
BEGIN
.......
END '
dbo.sp_executesql @statement = N'
Using c sharp code my code uploaded

Attachment: scriptgenerate.zip

Answers (2)