Create a CLR custom trigger-c#

Triggers | Creating the first step: Writing code in Visual Studio 2005
Using System;
Using System.Data;
Using SYSTEM.DATA.SQL;
Using System.Data.SqlServer;
Using System.Data.SqlTypes;
public partial class triggers
{
Enter existing table or view for the target and uncomment
[Sqltrigger (Name= "Mytrigger", target= "Table1", event= "for UPDATE")]
public static void Mytrigger ()
{
SqlTriggerContext Mytriggercontext = Sqlcontext.gettriggercontext ();
SqlPipe mypipe = Sqlcontext.getpipe ();
SqlCommand mycommand = Sqlcontext.getcommand ();
if (mytriggercontext.triggeraction = = Triggeraction.insert)
{
myCommand.CommandText = "SELECT * from Sptesttbl";
}
Mypipe.execute (mycommand);
}
}

Step two: Compile, deploy (Build,deploy)
Step three: Register to Yukon
Grammar:
CREATE TRIGGER trigger_name on table_name for insert| update| DELETE
As EXTERNAL NAME Assembly_name.class_name.clr_trigger_name

Example:
CREATE TRIGGER Mytrigger on TESTTBL1 for INSERT
As EXTERNAL NAME UDT. Triggers.mytrigger