Search code examples
t-sql

How to insert default values in SQL table?

I have a table like this:

create table1 (field1 int,
               field2 int default 5557,
               field3 int default 1337, 
               field4 int default 1337)

I want to insert a row which has the default values for field2 and field4.

I've tried insert into table1 values (5,null,10,null) but it doesn't work and ISNULL(field2,default) doesn't work either.

How can I tell the database to use the default value for the column when I insert a row?

Solution

  • Just don't include the columns that you want to use the default value for in your insert statement. For instance:

    INSERT INTO table1 (field1, field3) VALUES (5, 10);

    ...will take the default values for field2 and field4, and assign 5 to field1 and 10 to field3.