Post reply

Identity Insert

  • March 1, 2009 at 1:10 pm

    #201809

    Comments posted to this topic are about the item Identity Insert

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

  • March 2, 2009 at 4:21 am

    #951743

    See my thread.....

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

    😀

    --Shaun

    Hiding under a desk from SSIS Implemenation Work :crazy:

  • March 2, 2009 at 8:29 am

    #951893

    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.

  • March 2, 2009 at 10:31 am

    #951972

    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.

  • March 4, 2009 at 12:27 pm

    #953511

    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

  • March 9, 2009 at 1:16 pm

    #956357

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

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

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