Sql Server Defaults



defaults are used for inserting default values to tables when the field is skipped or inserted iwth default values

To dmonstrate lets create a table first


create table default_test
id int,
r_date datetime default(getdate()),
r_count int default(100)

Now insert values to fields except r_date

insert into default_test (id) values (1000)

r_date will be inserted with current date value

Again When the field is inserted with keyword default, this time too value on the r_date feld will be of current date

insert into default_test (id,r_date) values (1000,default)

But when insert value to this field it ll accept it over default

insert into default_test (id,r_date) values (1000,’2011-3-3′)