请问下这个问题如何解决
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE PROCEDURE adduser@name varchar(64),
@passwd binary(16),
@prompt varchar(32),
@answer varchar(32),
@truename varchar(32),
@idnumber varchar(32),
@email varchar(64),
@mobilenumber varchar(32),
@province varchar(32),
@city varchar(32),
@phonenumber varchar(32),
@address varchar(64),
@postalcode varchar(8) ,
@gender integer,
@birthday varchar(32),
@qq varchar(32),
@passwd2 binary(16)ASSET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON
SET NOCOUNT ON
SET XACT_ABORT ON BEGIN TRAN
DECLARE @id integer
SELECT @id = ISNULL(max(id), 16) + 16 FROM users HOLDLOCK
INSERT INTO users (id,name,passwd,prompt,answer,truename,idnumber,email,mobilenumber,province,city,phonenumber,address,postalcode,gender,birthday,creatime,qq,passwd2) VALUES( @id, @name, @passwd, @prompt, @answer, @truename, @idnumber, @email, @mobilenumber, @province, @city, @phonenumber, @address, @postalcode, @gender, @birthday, getdate(), @qq, @passwd2 )
COMMIT TRANGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO消息 1018,级别 15,状态 1,过程 adduser,第 33 行
'holdlock' 附近有语法错误。如果它要作为表提示的一部分,则必须有 WITH 关键字和圆括号。有关正确的语法,请参阅 SQL Server 联机丛书。
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE PROCEDURE adduser@name varchar(64),
@passwd binary(16),
@prompt varchar(32),
@answer varchar(32),
@truename varchar(32),
@idnumber varchar(32),
@email varchar(64),
@mobilenumber varchar(32),
@province varchar(32),
@city varchar(32),
@phonenumber varchar(32),
@address varchar(64),
@postalcode varchar(8) ,
@gender integer,
@birthday varchar(32),
@qq varchar(32),
@passwd2 binary(16)ASSET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ANSI_NULL_DFLT_ON ON
SET QUOTED_IDENTIFIER ON
SET NOCOUNT ON
SET XACT_ABORT ON BEGIN TRAN
DECLARE @id integer
SELECT @id = ISNULL(max(id), 16) + 16 FROM users HOLDLOCK
INSERT INTO users (id,name,passwd,prompt,answer,truename,idnumber,email,mobilenumber,province,city,phonenumber,address,postalcode,gender,birthday,creatime,qq,passwd2) VALUES( @id, @name, @passwd, @prompt, @answer, @truename, @idnumber, @email, @mobilenumber, @province, @city, @phonenumber, @address, @postalcode, @gender, @birthday, getdate(), @qq, @passwd2 )
COMMIT TRANGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO消息 1018,级别 15,状态 1,过程 adduser,第 33 行
'holdlock' 附近有语法错误。如果它要作为表提示的一部分,则必须有 WITH 关键字和圆括号。有关正确的语法,请参阅 SQL Server 联机丛书。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货