作者：chenyanni1030_430 | 来源：互联网 | 2023-01-31 20:58
CREATETABLE[dbo].[ChunkData]([ChunkID][uniqueidentifier]NOTNULL,[SnapshotDataID][uniqueide
CREATE TABLE [dbo].[ChunkData](
[ChunkID] [uniqueidentifier] NOT NULL,
[SnapshotDataID] [uniqueidentifier] NOT NULL,
[ChunkFlags] [tinyint] NULL,
[ChunkName] [nvarchar](260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ChunkType] [int] NULL,
[Version] [smallint] NULL,
[MimeType] [nvarchar](260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Content] [image] NULL,
CONSTRAINT [PK_ChunkData] PRIMARY KEY NONCLUSTERED
(
[ChunkID] ASC/*shengxu*/
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMACREATE TABLE [dbo].[ChunkData](
[ChunkID] [uniqueidentifier] NOT NULL,
[SnapshotDataID] [uniqueidentifier] NOT NULL,
[ChunkFlags] [tinyint] NULL,
[ChunkName] [nvarchar](260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ChunkType] [int] NULL,
[Version] [smallint] NULL,
[MimeType] [nvarchar](260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Content] [image] NULL,
CONSTRAINT [PK_ChunkData] PRIMARY KEY NONCLUSTERED
(
[ChunkID] ASC/*shengxu*/
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GE_ON [PRIMARY]
其中CREATE TABLE [dbo].[ChunkData](
[ChunkID] [uniqueidentifier] NOT NULL,
[SnapshotDataID] [uniqueidentifier] NOT NULL,
[ChunkFlags] [tinyint] NULL,
[ChunkName] [nvarchar](260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ChunkType] [int] NULL,
[Version] [smallint] NULL,
[MimeType] [nvarchar](260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Content] [image] NULL,
CONSTRAINT [PK_ChunkData] PRIMARY KEY NONCLUSTERED
(
[ChunkID] ASC/*shengxu*/
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
其中IGNORE_DUP_KEY = OFF？是什么意思啊
2.为什么还要在后面加 “TEXTIMAGE_ON [PRIMARY]”
谢谢
2 个解决方案
CREATE TABLE [dbo].[ChunkData](
[ChunkID] [uniqueidentifier] NOT NULL,
[SnapshotDataID] [uniqueidentifier] NOT NULL,
[ChunkFlags] [tinyint] NULL,
[ChunkName] [nvarchar](260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[ChunkType] [int] NULL,
[Version] [smallint] NULL,
[MimeType] [nvarchar](260) COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Content] [image] NULL,
CONSTRAINT [PK_ChunkData] PRIMARY KEY NONCLUSTERED
(
[ChunkID] ASC/*shengxu*/
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
其中
1.IGNORE_DUP_KEY = OFF？是什么意思啊
2.为什么还要在后面加 “TEXTIMAGE_ON [PRIMARY]”
谢谢
IGNORE_DUP_KEY
指定对唯一聚集索引或唯一非聚集索引的多行 INSERT 事务中重复键值的错误响应。
TEXTIMAGE_ON
是表示 text、ntext 和 image 列存储在指定文件组中的关键字。如果表中没有 text、ntext 或 image 列，则不能使用 TEXTIMAGE ON。如果没有指定 TEXTIMAGE_ON，则 text、ntext 和 image 列将与表存储在同一文件组中。
京公网安备 11010802041100号