主页 / dba / 问题 / 179578
Accepted
agpoweredmg
Asked: 2017-07-12 07:01:50 +0800 CST

消息 142，级别 15，状态 2 -- 无法弄清楚我出了什么问题

  • 772

我查看了其他线程以了解我收到的错误，但我没有看到我在哪里犯了错误，也没有看到任何额外的逗号，这似乎是问题的主要原因。如果有人能指出我犯错的地方，我将不胜感激。

CREATE TABLE Accounts.AdminUsers ( admID             INT              NOT NULL    IDENTITY(1,1)
                          , admFN            VARCHAR(35)      NULL
                          , admLN            VARCHAR(35)      NULL
                          , admUserName  VARCHAR(64)      NOT NULL
                          , admPass      VARCHAR(128)     NOT NULL
                          , admPassIV        VARCHAR(32)      NOT NULL
                          , admPassResetDate DATETIME2    NULL
                          , admEEID      VARCHAR(30)      NULL
                          , admEmail         VARCHAR(255)     NULL
                          , admAcctEnabled   BIT              NOT NULL
                          , admHier      HIERARCHYID      NOT NULL
                          , admNumLogins     SMALLINT         NULL
                          , admLastLogin     DATETIME2    NULL
                          , admCreateTS  DATETIME2    NOT NULL
                          , admTID       TINYINT          NOT NULL
                          , CONSTRAINT PK_Accounts_AdminUsers
                            PRIMARY KEY CLUSTERED (admID)
                          , CONSTRAINT DF_Accounts_AdminUsers_admAcctEnabled 
                            DEFAULT (1)
                          , CONSTRAINT DF_Accounts_AdminUsers_admCreateTS 
                            DEFAULT (CURRENT_TIMESTAMP)
                          , CONSTRAINT FK_Accounts_AdminUsers_AdminUserTypes
                            FOREIGN KEY (admTID) REFERENCES Accounts.AdminUserTypes(admTID)
                          );
sql-server

1 个回答

  1. Best Answer

    将 CONSTRAINT DEFAULT 移到字段定义旁边：

    CREATE TABLE Accounts.AdminUsers ( admID             INT              NOT NULL    IDENTITY(1,1)
                          , admFN            VARCHAR(35)      NULL
                          , admLN            VARCHAR(35)      NULL
                          , admUserName  VARCHAR(64)      NOT NULL
                          , admPass      VARCHAR(128)     NOT NULL
                          , admPassIV        VARCHAR(32)      NOT NULL
                          , admPassResetDate DATETIME2    NULL
                          , admEEID      VARCHAR(30)      NULL
                          , admEmail         VARCHAR(255)     NULL
                          , admAcctEnabled   BIT              NOT NULL CONSTRAINT DF_Accounts_AdminUsers_admAcctEnabled 
                            DEFAULT (1)
                          , admHier      HIERARCHYID      NOT NULL
                          , admNumLogins     SMALLINT         NULL
                          , admLastLogin     DATETIME2    NULL
                          , admCreateTS  DATETIME2    NOT NULL CONSTRAINT DF_Accounts_AdminUsers_admCreateTS 
                            DEFAULT (CURRENT_TIMESTAMP)
                          , admTID       TINYINT          NOT NULL
                          , CONSTRAINT PK_Accounts_AdminUsers
                            PRIMARY KEY CLUSTERED (admID)
                          );
    • 3

相关问题