DECLARE @vTable CHAR(60),@strWhere CHAR(60)
……
………
exec ('select * into ##tepTable FROM '+@vTable +' Where '+@strWhere)
……
………
exec ('select * into ##tepTable FROM '+@vTable +' Where '+@strWhere)
[交流]动态SQL语句
--无效。可先建#tmptable表啊。