Daily Archives: June 2, 2011

Duplicate Identity Values?

Can you have duplicate values in a field with the identity property? Of course, and this does it. DROP TABLE dbo.MyTable CREATE TABLE mytable ( id INT IDENTITY(1,1) , mychar VARCHAR(10) ) GO INSERT mytable SELECT ‘A’ INSERT mytable SELECT … Continue reading

Posted in Blog | Tagged ,