1 cast (@A as varchar)或者convert(varchar,@A)2 declare @sql varchar(300)
declare @s varchar(30)
set @s = 'aaaa'
set @sql = 'bb' + @s + 'cc'3 set @sql='select * from table1 where data='''+convert(varchar,@date_b) + ''''
exce(@sql)
declare @s varchar(30)
set @s = 'aaaa'
set @sql = 'bb' + @s + 'cc'3 set @sql='select * from table1 where data='''+convert(varchar,@date_b) + ''''
exce(@sql)
cast (@A as varchar(10))2、set @sql='select * from table1 where data='''+@date_b+'''' --这个日期怎么加.引号
exce(@sql)