Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Archives: June 2011

A Welcome Break

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

0 comments, 111 reads

Posted in The Voice of the DBA on 6 June 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…

Read more

1 comments, 1,054 reads

Posted in The Voice of the DBA on 2 June 2011

Newer posts