34,590
社区成员
发帖
与我相关
我的任务
分享
ADD CONSTRAINT ck_Newspaper
CHECK(cPhone LIKE like '0[0-9][0-9][0-9] [0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
or cPhone LIKE like '0[0-9][0-9] [0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
create table #(cPhone char(13) check
(cPhone like '[0-9][0-9][0-9][0-9] [0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'));
检查约束
alter table tb add constraint ck_f check(len(cPhone)=11 and ISNUMERIC(cphone)=1)