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
Posted by Far-Rider at 8:50 AM
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)