Home Forums SQL Server 2005 T-SQL (SS2K5) insert a table row where every column has a default RE: insert a table row where every column has a default

  • --

    INSERT INTO T1 DEFAULT VALUES;

    --

    This is right out of the examples in Books Online for the INSERT statement. Sometimes it's as easy to RTFM as it is to ask a forum. 😉

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills