skip to main
|
skip to sidebar
Moments shared with SQL Server
Thursday, December 2, 2010
Inserting into a table with single column and identity
How can you insert a row in a table with the following definition:
CREATE TABLE T (A INT IDENTITY (1,1))
Hmmmm..it is ridiculously simple as:
INSERT T DEFAULT VALUES
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)
Blog Archive
►
2013
(1)
►
January
(1)
►
2011
(4)
►
October
(1)
►
June
(1)
►
May
(1)
►
April
(1)
▼
2010
(23)
▼
December
(1)
Inserting into a table with single column and iden...
►
September
(4)
►
August
(1)
►
July
(1)
►
March
(4)
►
January
(12)
►
2009
(1)
►
May
(1)
►
2008
(14)
►
April
(1)
►
March
(2)
►
February
(11)
►
2007
(16)
►
October
(7)
►
September
(4)
►
August
(4)
►
May
(1)