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);