新建内存优化表

CREATE TABLE new_AccountPromotion
    (
      [new_GUID] uniqueidentifier NOT NULL,
      [new_AccountNumber] NCHAR(50) COLLATE Chinese_PRC_Stroke_90_BIN2  NOT NULL,
      [new_MobilePhone] NCHAR(20) COLLATE Chinese_PRC_Stroke_90_BIN2  NOT NULL,
      [new_PromotionID] NCHAR(50) COLLATE Chinese_PRC_Stroke_90_BIN2 NOT NULL ,
      [new_PromotionNumber] NCHAR(50) COLLATE Chinese_PRC_Stroke_90_BIN2 NOT NULL 
      PRIMARY KEY NONCLUSTERED   HASH WITH (BUCKET_COUNT = 268435456),
      [new_StartDate] DateTime  NOT NULL ,
      [new_EndDate] DateTime  NOT NULL ,
      [new_IsLimitTimes] int  NOT NULL ,
      [new_CurrentFlag] int  NOT NULL 
    )
WITH (MEMORY_OPTIMIZED = ON, DURABILITY = SCHEMA_AND_DATA);