THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server » Database Unit T... » Database Programming   (RSS)
  • Fun with DBCC CHECKIDENT

    <Denis Gobo’s mode on> Suppose you have an empty table:   SELECT COUNT(*) FROM SampleTable --- 0   What would be the result of the following query:   DBCC CHECKIDENT('SampleTable', RESEED, 1) INSERT SampleTable(j) SELECT 1 SELECT SCOPE_IDENTITY()   <Denis Gobo’s mode ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on June 26, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement