Set @ SQL="insert into ftable (fieldname, oldval, newval)-CodePudding

Home > database > Set @ SQL="insert into ftable (fieldname, oldval, newval)

Set @ SQL="insert into ftable (fieldname, oldval, newval)

Time：03-10

Values (" '+ ZCBM +' ' ', '1233', '22', ') '

The quotation mistakes always orders

CodePudding user response:

Up and down together,

CodePudding user response:

ZCBM is another table field?

 
Declare @ SQL varchar (1000) 

The set @ SQL="insert into ftable select ZCBM, ' '1233', ' ' '22' 'the from table_xxxx'