Ms SqlServer:
declare @sql varchar(1000),@temp varchar(10)
set @sql = 'insert into fz (fzgh) values('+'''ddddd'''+')'
exec (@sql);
请注意字符串的左右全是单引号。
Oracle:
strsql varchar2(200);
begin
strsql :='SELECT K.KSDM KSDM, K.KSMC KSMC, nvl(AA.NEED, 0) NEED, nvl(BB.NEED, 0) FINISH,
nvl(BB.NEED*1.0/AA.NEED, 0) AS FINISHPER, nvl(CC.NEED, 0) + nvl(DD.NEED, 0) AS FACT,
nvl(CC.NEED, 0) AS FIRST, nvl(DD.NEED, 0) AS AGAIN,
nvl(CC.NEED*1.0/(CC.NEED + nvl(DD.NEED, 0)), 0) AS FIRSTPER,
nvl(DD.NEED*1.0/(nvl(CC.NEED, 0) + DD.NEED), 0) AS AGAINPER
FROM GY_KSDM K, HJZX_AA AA, HJZX_BB BB, HJZX_CC CC,HJZX_DD DD WHERE K.KSDM > 400 AND K.BQSY = '||temp||'Y'||temp||' AND
K.KSDM=AA.KSDM AND K.KSDM=BB.KSDM AND K.KSDM=CC.KSDM AND K.KSDM=DD.KSDM';
execute immediate(strsql);
end
请注意拼接是采用||进行的。