22,210
社区成员
发帖
与我相关
我的任务
分享
select 可以 update 不行
select nickname = '['+convert(varchar,zs)+'★]' + ltrim(nickname) from Character
update Character set nickname = '['+convert(varchar,zs)+'★]' + nickname
update Character set nickname = '['+convert(varchar,zs)+'★]nickname'
update Character set nickname = '['+convert(varchar,zs)+'★]' + nickname