�S�㽨һ��(g��)�����磺

select '1--0001' as c_id into #t

Ȼ���(zh��)�в�ԃ(x��n)��

select * from #t where c_id like '1--%'

�Y(ji��)���](m��i)�e(cu��)���](m��i)��(w��n)�}�����o�@��(g��)������(g��)���I��

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--%'

�І�(w��n)�}�ˣ����ټ����(l��i)�Ƶģ�

insert #t select '11--%'

�ٲ�飺

select * from #t where c_id like '11--%'

����