随便建一个表,如:
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]
然后再查查看:
有问题了,但再加了类似的:
insert #t select '11--%'
再查查:
select * from #t where c_id like '11--%'
晕了