裁取表某列值

 UPDATE ac10070600000018.dbo.FS_AssetsLia SET Name=SUBSTRING(Name,1,DATALENGTH(Name)-1)