SQL Default 约束的初步认识和理解! 首先创建一张表hello CREATE TABLE hello ( Id_P int PRIMARY KEY, Firstname varchar(50), Lastname varchar(50), Address varchar(50), City varchar(50) ) 创建约束条件 CREATE DEFAULT beijing_const AS 'beijing' 绑定约束条件到列上 sp_bindefault beijing_const,'hello.Address' sp_bindefault beijing_const,'hello.City' 插入一条信息 INSERT INTO hello(Id_P,Firstname,Lastname) values(01,'Bush','Green') 最后结果是