Part 30 Constraints Default
create table test1
(
id int,
name varchar(100) default 'Raptor'
)
select * from test1
insert into test1(id) values(1)
insert into test1(id,name) values(2,'Tom')
sql #sqlserver #sqltutorial #sqltutorialforbeginners