Posted by Jim C on 11/28/06 21:29

!!!
Bad side effect: TRUNCATE TABLE resets the identity column to 1. Dumb,
poorly documented feature. Needs to have an optional NO IDENTITY RESET
clause.

So I have to use DELETE instead, that's ok.

• Next in forum: Re: Equivalent to SQL Anywhere GET_IDENTITY?
• Prev in forum: SQL Server 2005 objects question
• Thread view: Re: Equivalent to SQL Anywhere GET_IDENTITY?

[Reply to this message]