You are here: Re: IDENT_CURRENT and empty table « MsSQL Server « IT news, forums, messages
Re: IDENT_CURRENT and empty table

Posted by Dan Guzman on 09/18/05 20:58

http://support.microsoft.com/default.aspx?scid=kb;en-us;835188

--
Hope this helps.

Dan Guzman
SQL Server MVP

"helmut woess" <hw@iis.at> wrote in message
news:1q6jrdv4416ek.9i6nx8fks7bc$.dlg@40tude.net...
> Hi,
>
> can somebody explain me, why the IDENT_CURRENT from an empty table is 1?
> After insert of the first record it is still 1 (assuming that start value
> is 1) which is okay. But if i check the IDENT_CURRENT from a newly created
> table the result should be NULL, or not?
>
> bye,
> Helmut

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация