New SQL Server project templates for VS2015 (CSSqlTrigger.cs)
1: using System;
2: using System.Data;
3: using System.Data.SqlClient;
4: using Microsoft.SqlServer.Server;
5:
6: public partial class Triggers
7: {
8: // $SqlClrTriggerComment$
9: // [Microsoft.SqlServer.Server.SqlTrigger (Name="$safeitemname$", Target="Table1", Event="FOR UPDATE")]
10: public static void $safeitemname$ ()
11: {
12: // $ReplaceCodeComment$
13: SqlContext.Pipe.Send("$TriggerFiredString$");
14: }
15: }
Comments (
)
Link to this page:
//www.vb-net.com/VS2015-SQL-Server-Project-Templates/CSSqlTrigger-cs.htm
|