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

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

Ȼ���(zh��)�в�ԃ��

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

�Y(ji��)���]�e(cu��)���]���}�����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--%'

�І��}�ˣ����ټ�����Ƶģ�

insert #t select '11--%'

�ٲ�飺

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

����