摘要: @check约束例:创建Users,要求电子邮件必须包括“@”解:create table users(uid int primary key ,uname char(32),ueamil char(32)Usex bit ,check (ueamil char(32) like ‘%@%’))@默认约束例:要求性别默认为1 ,性别不能为空解:create table users(uid int primary key ,uname char(32),ueamil char(32)Usex bit default ‘1’not null ,check (ueamil char(32) like 阅读全文
posted @ 2012-06-20 16:35 左正 阅读(538) 评论(0) 推荐(0)