SQLSERVER

删除前面的字符

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

posted @ 2017-08-04 08:42  oneboi  阅读(152)  评论(0)    收藏  举报