SQL语法错误, '(' 附近有语法错误,求解
发布网友
发布时间:2024-10-01 18:26
我来回答
共3个回答
热心网友
时间:2024-10-10 07:32
[IsOff] [bit] NOT NULL CONSTRAINT [DF_xHishop_ProctsOffShelf_IsOff] DEFAULT
这个少了个,号
修改如下
[IsOff] [bit] NOT NULL, CONSTRAINT [DF_xHishop_ProctsOffShelf_IsOff] DEFAULT
热心网友
时间:2024-10-10 07:32
是少逗号的问题
[IsOff] [bit] NOT NULL
CONSTRAINT [DF_xHishop_ProctsOffShelf_IsOff] DEFAULT
改为
[IsOff] [bit] NOT NULL,
CONSTRAINT [DF_xHishop_ProctsOffShelf_IsOff] DEFAULT
热心网友
时间:2024-10-10 07:33
CREATE TABLE [xHishop_ProctsUpAndOffShelf](
[RecId] [int] IDENTITY(1,1) NOT NULL,
[ProctId] [int] NOT NULL,
[OccurDate] [datetime] NOT NULL,
[IsOff] [bit] NOT NULL ,
CONSTRAINT [DF_xHishop_ProctsOffShelf_IsOff] DEFAULT ((1)),
CONSTRAINT [PK_xHishop_ProctsUpAndOffShelf] PRIMARY KEY CLUSTERED
([RecId] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]