update Tbl_chick set id='310104'+right(id,len(id)-6)
--逐条修改 update Tbl_chick set id=stuff(id,1,6,'310104') where ID = '110101198506020054' ]--批量修改 update Tbl_chick set id=stuff(id,1,6,'310104') where left(ID,6) = '110101' 建议在生产数据库上直接update时,带上where,习惯会带给你好运!
set id='310104'+right(id,len(id)-6)
update Tbl_chick set id=stuff(id,1,6,'310104') where ID = '110101198506020054'
]--批量修改
update Tbl_chick set id=stuff(id,1,6,'310104') where left(ID,6) = '110101'
建议在生产数据库上直接update时,带上where,习惯会带给你好运!