(SQL) SQL (2014)

New SQL Server project templates for VS2015 (Create User Defined Table Type MemOpt.sql)

   1:  /*
   2:  $DatabaseMustHaveMemOptFilegroupComment$
   3:  */
   4:   
   5:  CREATE TYPE $SchemaQualifiedObjectName$ AS TABLE
   6:  (
   7:      Id INT NOT NULL IDENTITY PRIMARY KEY NONCLUSTERED HASH WITH (BUCKET_COUNT=131072), 
   8:      Name VARCHAR(128)
   9:  ) WITH (MEMORY_OPTIMIZED = ON)


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