All Tags »
Database Testin... »
Database Progra... »
SQL Server »
Database Unit Testing (RSS)
Sorry, but there are no more tags available to filter with.
-
<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 ...