摘要: create table t3(a char(10),b char(10),c char(10),d char(10))create table te(a varchar(10) primary key not null,b int)insert into te values('1',200)insert into te values('',1)select * from teALTER TABLE te ADD CONSTRAINT CK_b CHECK(b>=1)GO------------------------------------------- 阅读全文
posted @ 2012-08-05 19:31 blog_yuan 阅读(6005) 评论(0) 推荐(0) 编辑