22,209
社区成员
发帖
与我相关
我的任务
分享
ALTER TABLE s_ccode ADD ccode VARCHAR(50)
UPDATE s_ccode SET ccode=cdlcode+CAST(sid AS VARCHAR(20))
declare
begin
execute immediate 'ALTER TABLE s_ccode ADD ccode VARCHAR(50)';
execute immediate 'UPDATE s_ccode SET ccode=CAST(sid AS VARCHAR(20))';
end;