Loading

Create script of trigger

jayakrishnan Morayur

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
refer msdn forum sample
0
Mahesh Chand15y ago
Unfortunately I do not have time to look at the code.

Do you know the table name, trigger name and all other variables you need in a Trigger SQL syntax? If yes, you just need to build a string with some hardcoded values and some variables.

string triggerString = "CREATE TRIGGER [dbo." + TableName + "] ON " .. and keep building your string.
0