Home Forums SQL Server 2008 SQL Server 2008 - General Instance: table column with default value RE: Instance: table column with default value

  • July 30, 2014 at 8:50 am

    #1733645

    Is required to set the null value after the field type?

    It is not required.

    What can happen if null is not defined?

    If you don't set the NULL option then it will be nullable.

    create table Test1 (

    ExpirationDate datetime);

    go


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]