set @sql='update #bb set ida=2 where idb='+@tmp 结果: update #bb set ida=2 where idb=aaa set @sql='update #bb set ida=2 where idb='''+@tmp+'''' 结果: update #bb set ida=2 where idb='aaa'
有些地方用"也可以 set @sql='update #bb set ida=2 where idb="'+@tmp+'"' 不过推荐用''
结果:
update #bb set ida=2 where idb=aaa
set @sql='update #bb set ida=2 where idb='''+@tmp+''''
结果:
update #bb set ida=2 where idb='aaa'
set @sql='update #bb set ida=2 where idb="'+@tmp+'"'
不过推荐用''