Archives: June 2011
I’m not working, though I have checked some email and kept an eye on a few things while I’m in Pensacola, FL. I have made an effort, however, to not work, and not respond to emails that weren’t very time critical. Mostly I’m just trying to prune down things that… Read more
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…