随便建一个表,如:
select '1--0001' as c_id into #t
然后执行查询:
select * from #t where c_id like '1--%'
结果没错,没问题啊,给这个表建个主键:
ALTER TABLE #t WITH NOCHECK ADD
CONSTRAINT [PK_temp] PRIMARY KEY CLUSTERED
(
[c_id]
) WITH FILLFACTOR = 90 ON [PRIMARY]
然后再查查看:
select * from #t where c_id like '1--%'
有问题了,但再加了类似的:
insert #t select '11--%'
再查查:
select * from #t where c_id like '11--%'
晕了