Sqlserver Replease

 

select G_DiQuMa from NongCun_GangWei

select REPLACE(G_DiQuMa,'82','99') from NongCun_GangWei
查找G_diquma 字段，替换掉G_diquma中82的值修改成99

 

update NongCun_GangWei set G_NianLing=REPLACE(G_NianLing,1988,1989) where G_SN=516
修改G_NianLing 字段值1988等于1989