Identity Insert

  • Aram Koukia

    SSCommitted

    Points: 1521

    Comments posted to this topic are about the item Identity Insert

    [font="Courier New"]Aram Koukia: http://www.koukia.ca[/font]
  • Shaun McGuile

    SSCarpal Tunnel

    Points: 4111

    See my thread.....

    http://www.sqlservercentral.com/Forums/Topic622104-338-1.aspx

    😀

    --Shaun

    Hiding under a desk from SSIS Implemenation Work :crazy:

  • brdudley

    SSCrazy

    Points: 2268

    I came across the Insert Default Values when I taught a SQL class, many years back. It was an odd way to start a chapter on data modification statements. It is mostly useful for trivia contests, to be honest.

    The best explanation I can come up with, for where it might be used, is in a situation -- like a call center -- where you want to latch an identity, but don't have enough data to fill in the blanks. There might be some uses around logging, but usually there is more to be recorded.

  • James Rochez

    SSCrazy

    Points: 2029

    Note that

    insert into TableName default values

    should not be confused with

    insert into TableName (columnName) values(default)

    The latter of which is not valid for an identity column.

  • Tom Garth

    SSCertifiable

    Points: 6173

    I can't picture ever using this knowledge, but learning it is still cool.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • 297t73g

    SSChasing Mays

    Points: 600

    gezz,, I am missing the point of this. I thought the User needs to insert data ?

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply