34,590
社区成员
发帖
与我相关
我的任务
分享
ALTER TABLE [dbo].[tb] WITH CHECK ADD
CONSTRAINT [ck_tb] CHECK (ascii(left(编号,1)) between 65 and 90 and
ascii(substring(编号,2,1)) between 65 and 90 and right(编号,4) like '[0-9][0-9][0-9][0-9]')
create table tb(编号 VARCHAR(20) CHECK (编号 LIKE '[A-Z][A-Z][0-9][0-9][0-9][0-9]))
alter table tb add check(编号 like '[A-Z][A-Z][0-9][0-9][0-9][0-9]' collate Chinese_PRC_BIN)