IDENT_CURRENT, from which place this func takes da

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 2000 Forums

SQL Server Development (2000)

IDENT_CURRENT, from which place this func takes da

Author

Topic

marconi8
Yak Posting Veteran

73 Posts

Posted - 2003-04-28 : 16:07:43

from which place ( i think place is located somewhere in sys tables , or ???) this function takes data

IDENT_CURRENT('table_name')
=====================================================

i only want to do this....

UPDATE table( table where is located last identity value)
set IDENT_CURRENT=IDENT_CURRENT+1

it is possible ?

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-04-28 : 16:19:11

You will want to run DBCC CHECKIDENT to update the identity value of a specific table. Please see SQL Server Books Online for the details, but here is an example:

DBCC CHECKIDENT (Table1, RESEED, 455)
GO

This example changes the identity value to 455 for the table named Table1.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources