如何在SQL2000里面删除部分表

来源：百度知道 编辑：UC知道 时间：2024/05/28 18:13:02
怎么样在表t_qyrk里面,删除列名为per_code中的一部分行,要删除的是编码前面9位数为"451102103"(编码总长为18位)的全部行?

delete from t_qyrk
where left(per_code,9)='451102103'

update t_qyrk
set per_code=stuff( per_code,1,9,'')
where per_code like'451102103%'

update t_qyrk
set per_code=''
where
left(per_code,9)='451102103'
and
len(per_code)=18

DELETE t_qyrk WHERE per_code LIKE '451102103%'
或
DELETE t_qyrk WHERE LEFT(per_code, 9) = '451102103'

如果需要指定编码长度，则
DELETE t_qyrk WHERE per_code LIKE '451102103%' AND LEN(per_code)=18