MSSQL 2K 下 exec ('use table') 无效

Question

exec ('use table') 显示“命令已成功完成。”，但是并没有切换到相应的table

Answer 1

exec的变数只对()内有效
Try

exec('use tabledb;select * from table');

http://blog.sqlauthority.com/2007/09/13/sql-server-difference-between-exec-and-execute-vs-exec-use-execexecute-for-sp-always/