Home Forums SQL Server 2008 SQL Server Newbies Adding record to db using stored procedure and identity counter. RE: Adding record to db using stored procedure and identity counter.

  • October 25, 2012 at 9:56 am

    #1552784

    I typed in the line

    DECLARE @NewVal BIGINT = (SELECT MAX(member_id) FROM dbo.member WITH (TABLOCKX))+1;

    exactly ... and I get a syntax error Incorrect near '('