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.NE......
阅读全文