declare name varchar(40); sqlstr varchar2(8000);name :='column3' sqlstr:='update t set '||name||' = xxx where ...'execute immediate sqlstr;
多谢libin_ftsafe(子陌红尘) ( ) ! 我去试试
在 SQL SERVER 中怎么写?
declare @name varchar2(40),@sqlstr varchar2(8000)set @name='column3' set @sqlstr='update t set '+name+'=''mmm'' where ...'exec(@sqlstr)
try: ------------------------------------------------------------------------------------ declare name varchar2(40); sqlstr varchar2(8000);name :='column3' sqlstr:='update t set '||name||' = "mmm" where ...'execute immediate sqlstr;
SQL Server 2000: --------------------------------------------------------------------------- declare @name varchar(40),@sqlstr varchar(8000)set @name='column3' set @sqlstr='update t set '+name+'=''mmm'' where ...'exec(@sqlstr)
sqlstr varchar2(8000);name :='column3'
sqlstr:='update t set '||name||' = xxx where ...'execute immediate sqlstr;
set @sqlstr='update t set '+name+'=''mmm'' where ...'exec(@sqlstr)
------------------------------------------------------------------------------------
declare name varchar2(40);
sqlstr varchar2(8000);name :='column3'
sqlstr:='update t set '||name||' = "mmm" where ...'execute immediate sqlstr;
---------------------------------------------------------------------------
declare @name varchar(40),@sqlstr varchar(8000)set @name='column3'
set @sqlstr='update t set '+name+'=''mmm'' where ...'exec(@sqlstr)