exec('select cast(''123'' as float)'+'/'+'cast(''10'' as float)')
即:
Create Table Table2(ID int,ID2 varchar(10),ID3 varchar(10),OPC varchar(10))
Insert Into Table2(ID,ID2,ID3,OPC) Values(1,'12','10','/')
则:
declare @AA varchar(10)
select @AA=OPC From Table2 where [ID]=1
exec('select cast(ID2 as float) '+@AA+' cast(ID3 as float) From Table2 where [ID]=1')