if object_id('test')is not null drop table test go create table test([ID] varchar(20) check ([ID] like '00[0-9][0-9][_][A-Z][A-Z][A-Z]')) insert test select '0023_ABC' select * from test /* ID -------------------- 0023_ABC(1 個資料列受到影響)*/
([ID] like '00[0-9][0-9][_][A-Z][A-Z][A-Z]')
CREATE TABLE TBTEST([ID] VARCHAR(50) CHECK (ID like '00[0-9][0-9][_][A-Z][A-Z][A-Z]'))INSERT TBTEST SELECT '0023_abc'--drop table tbtestselect * from tbtestID -------------------------------------------------- 0023_abc(所影响的行数为 1 行)
create table # (id char(8) check (id like '00[0-9][0-9]\_[A-Z][A-Z][A-Z]' escape '\'));insert into # values('0023_ABC'); insert into # values('0023-ABC');select * from #;
create table #tt ( iid nvarchar(100) check(iid like '00[0-9][0-9][_][A-Z][A-Z][A-Z]')) insert into #tt values('0023_bbb')
--这是添加还是查询啊!?
check ([ID] like '00[0-9][0-9]_[A-Z][A-Z][A-Z]'))
你的_是想要任意匹配还是就是一个_
go
create table test([ID] varchar(20)
check ([ID] like '00[0-9][0-9][_][A-Z][A-Z][A-Z]'))
insert test select '0023_ABC'
select * from test
/*
ID
--------------------
0023_ABC(1 個資料列受到影響)*/
--------------------------------------------------
0023_abc(所影响的行数为 1 行)
create table # (id char(8) check (id like '00[0-9][0-9]\_[A-Z][A-Z][A-Z]' escape '\'));insert into # values('0023_ABC');
insert into # values('0023-ABC');select * from #;
#tt
(
iid nvarchar(100) check(iid like '00[0-9][0-9][_][A-Z][A-Z][A-Z]'))
insert into #tt values('0023_bbb')