SQLSERVER

删除前面的字符

update T_B_PartyBusinessNews set OrganizationCode=right (OrganizationCode,LEN(OrganizationCode)-3) where id >= 137;

posted @ 2017-08-04 08:42  金于虎  阅读(142)  评论(0编辑  收藏  举报