(SQL) SQL (2014)

New SQL Server project templates for VS2015 (Create Table Function.sql)

   1:  CREATE FUNCTION $SchemaQualifiedObjectName$
   2:  (
   3:      @param1 int,
   4:      @param2 char(5)
   5:  )
   6:  RETURNS @returntable TABLE
   7:  (
   8:      c1 int,
   9:      c2 char(5)
  10:  )
  11:  AS
  12:  BEGIN
  13:      INSERT @returntable
  14:      SELECT @param1, @param2
  15:      RETURN
  16:  END


Comments ( )
Link to this page: //www.vb-net.com/VS2015-SQL-Server-Project-Templates/Create-Table-Function-sql.htm
< THANKS ME>