Posted by Jim C on 11/27/06 23:29

Is there an equivalent in mssql to SQL Anywhere's GET_IDENTITY which
reserves the next autoinc value for a table? Yes I know about
@@Identity and SCOPE_IDENTITY. I need to get the next autoinc value
_before_ I insert the record due to the way the existing application
works.

I've seen DBCC CHECKIDENT mentioned but that seems kludgy to me.

TIA,
Jim

• Next in forum: Re: Equivalent to SQL Anywhere GET_IDENTITY?
• Prev in forum: Re: Transposing repetitive serial fields into Table structure
• Thread view: Equivalent to SQL Anywhere GET_IDENTITY?

[Reply to this message]