摘要: (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 阅读全文
posted @ 2014-01-15 17:12 盛开的雨季 阅读(829) 评论(0) 推荐(0) 编辑