SQL Error in Procedures

Results 1 to 2 of 2
  1. #1
    Novice Axxiff is offline
    MemberRank
    Nov 2006 Join Date
    4Posts

    SQL Error in Procedures

    Hello. I got the problem that the batch cant add the Procedure "addUser".
    I get the following Error
    Msg 1018, Level 15, State 1, Procedure adduser, Line 33
    wrong syntax near 'holdlock'
    and this is the Query

    SET QUOTED_IDENTIFIER ON
    GO
    SET ANSI_NULLS ON
    GO

    CREATE 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)

    AS

    SET 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 TRAN

    GO
    SET QUOTED_IDENTIFIER OFF
    GO
    SET ANSI_NULLS ON
    GO
    soo... Anyone have a clue? =)

    Thanks in advance


  2. #2
    Member dark9011 is offline
    MemberRank
    Jul 2006 Join Date
    Edinburg, TexasLocation
    63Posts

    Re: SQL Error in Procedures

    Changed holdlock to (holdlock)



Advertisement