(SQL) SQL (2014)

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
< THANKS ME>