Identity Insert

  • Comments posted to this topic are about the item Identity Insert

    [font="Courier New"]Aram Koukia: http://www.koukia.ca[/font]
  • See my thread.....

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

    😀

    --Shaun

    Hiding under a desk from SSIS Implemenation Work :crazy:

  • 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.

  • 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.

  • 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
  • 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