|
|
|
|
Browse by Tags
All Tags » Database Testin... » Database Progra... » SQL Server (RSS)
-
<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 ...
|
|
|
|
|