• Raghavendra Mudugal (5/3/2013)


    Toreador (5/3/2013)


    Danny Ocean (5/2/2013)


    Most of people don't know about it because it's not in use in any real scenario.

    Sure it is, if the table contains other columns, all with defaults.

    As a simplistic example:

    CREATE TABLE TableA(ID INT IDENTITY (1,1),

    LastUpdated datetime default (getdate()))

    I don't use this technique often, but have used it in production systems before.

    ... what Mr. Ocean meant was to use the defaults with the combination of identity column.

    (the example what you have given is very nice and we have that set up in the prod server for one database. it actually reduces couple of parameters while inserting - createdate or updating the date)

    nice explanation... But i have another column in this table "Name" this column is not have default properties.

    will this property allow to insert???:w00t:

    Manik
    You cannot get to the top by sitting on your bottom.