Press enter to see results or esc to cancel.

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′)


Comments are disabled for this post