摘要:
(1) 字符串替换Update SongADD_EMH0055 SET songno = REPLACE(songno, '231', '233') where songno like '%102231%'(2) 2个字段拼接成一个字段查询 MaxGroupName MaxGroupNameEnselect MaxGroupID, cast(MaxGroupName as varchar(50))+'('+cast(MaxGroupNameEn as varchar(50)) + ')'as MaxGroupNam 阅读全文