Prev: Getting primary/foreign keys and referenced tables and columns
Next: SQL 2008 passing Table-Value-parameters to stored proc via ODBC
From: tedpottel on 19 Dec 2009 19:56 Hi, How can I make a column auto increment ? -Ted
From: B.Edwards on 19 Dec 2009 21:02
CREATE TABLE Customer (CustomerKey int IDENTITY(1,1) CONSTRAINT PK_Customer PRIMARY KEY NOT NULL, SurName varchar(40), GivenName varchar(50)) "tedpottel" <tedpottel(a)gmail.com> wrote in message news:46f90526-34c3-49dd-8991-0ffe6526c399(a)u7g2000yqm.googlegroups.com... > Hi, > How can I make a column auto increment ? > -Ted |