6,129
社区成员
发帖
与我相关
我的任务
分享
--Drop table if it already exists.
IF OBJECT_ID('dbo.biao','U') IS NOT NULL
DROP TABLE dbo.Tong
GO
CREATE TABLE dbo.biao
(
ID int NOT NULL identity,
KSKC varchar(90) NOT NULL,
ISBN varchar(30) NULL,
JCMC varchar(90) NOT NULL,
CBS varchar(90) NOT NULL,
XBX varchar(20) NOT NULL,
BJ varchar(30) NOT NULL,
BB varchar(20) NULL,
ZZ varchar(80) NULL,
YM varchar(50) NOT NULL,
XH varchar(30) NOT NULL INDEX index_memoryoptimizedtable_XH NONCLUSTERED (XH),
XM varchar(20) NOT NULL,
DG varchar(10) NOT NULL,
SSZ varchar(2) NOT NULL,
CONSTRAINT PK_memoryoptimizedtable PRIMARY KEY NONCLUSTERED (ID),
-- See SQL Server Books Online for guidelines on determining appropriate bucket count for the index
INDEX hash_index_memoryoptimizedtable_ HASH (XH) WITH (BUCKET_COUNT = 9000)
) WITH (MEMORY_OPTIMIZED = ON, DURABILITY = SCHEMA_AND_DATA)
GO
USE [MemoryDB]
GO
CREATE TABLE [dbo].[MemTab]
(
ID [INT] NOT NULL,
Name [NVARCHAR](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
Type [NVARCHAR](20) COLLATE Chinese_PRC_CI_AS NOT NULL,
PRIMARY KEY NONCLUSTERED HASH
(
ID
)WITH ( BUCKET_COUNT = 1024)
)WITH ( MEMORY_OPTIMIZED = ON , DURABILITY = SCHEMA_AND_DATA )
GO
INSERT INTO [MemTab](ID,Name,Type) VALUES(1,'Roy','Type1');
SELECT * FROM MemTab;
UPDATE MemTab SET Name='Roy_88'
SELECT * FROM MemTab;
DELETE MemTab;
SELECT * FROM MemTab;
--DROP TABLE MemTab;
ALTER DATABASE 数据库名 SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT ON
最后还是非常感谢版主的帮忙。否则我也不会成功的。IF OBJECT_ID('dbo.biao','U') IS NOT NULL
DROP TABLE dbo.biao
GO
CREATE TABLE dbo.biao
(
ID int NOT NULL IDENTITY CONSTRAINT PK_memoryoptimizedtable PRIMARY KEY NONCLUSTERED (ID),
KSKC varchar(90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
ISBN varchar(30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
JCMC varchar(90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
CBS varchar(90) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
XBX varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
BJ varchar(30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
BB varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
ZZ varchar(80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
YM varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
XH Nvarchar(30) COLLATE Chinese_PRC_BIN2 NOT NULL INDEX index_memoryoptimizedtable_XH NONCLUSTERED (XH),
XM varchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
DG varchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
SSZ varchar(2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
-- See SQL Server Books Online for guidelines on determining appropriate bucket count for the index
INDEX hash_index_memoryoptimizedtable_ HASH (XH) WITH (BUCKET_COUNT = 9000)
) WITH (MEMORY_OPTIMIZED = ON, DURABILITY = SCHEMA_AND_DATA);
参照:
https://msdn.microsoft.com/zh-cn/library/dn133182(v=sql.120).aspx