Creating IdentityValue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Creating IdentityValue

Author

Topic

baburk
Posting Yak Master

108 Posts

Posted - 2009-03-20 : 06:58:38

Hi,

I am creating my own IdentityValue like b1, b2,..

I truncated the table Test

Truncate table dbo.Test

SELECT 'b'+ CONVERT(VARCHAR, (IDENT_CURRENT ('dbo.Test'))) AS Current_Identity;
GO

b1

before Insert.

After record inserted,

Next Time also I got the same value

b1. So I got PrimaryKey Exception.

How can I able to create It.

Is there is any better way.

Thanks.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2009-03-20 : 07:41:05

Truncating reseeds the identity value. Use delete if you want to preserve identity value.
http://msdn.microsoft.com/en-us/library/ms175098.aspx