Post reply

DEFAULT ((0)) vs DEFAULT (0)

  • September 1, 2010 at 3:12 am

    #146817

    What is the difference between DEFAULT ((0)) and DEFAULT (0)?? Is there any?

    The reason I ask is that I am comparing databases on two SQL 2005 servers.

    One scripts the DEFAULTS on a particular table using two (()) and the other with only one ()?

    Thanks,

    Mark

  • September 1, 2010 at 3:19 am

    #1214801

    There's no functional difference, it's just a scripting quirk.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • September 1, 2010 at 3:24 am

    #1214805

    Ok thanks, I thought as much but just wanted to double check.

    Strangely I have another table that has a mix of the two?

  • September 1, 2010 at 3:26 am

    #1214806

    There is no difference but when you see the table structure in Desinger mode (in SSMS) then "Default value or Binding" displays "((0))" though during creation of table you have entered "0" or "(0)" as default value.

    Thanks

  • March 21, 2012 at 11:26 pm

    #1462520

    How to update if i need to make it unique(structure wise) in both the servers?

    Dropping and re-creating the constraint did not work out.Is there any other way?

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

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