exec ('use table') 显示“命令已成功完成。”,但是并没有切换到相应的table
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/
exec ('use table') 显示“命令已成功完成。”,但是并没有切换到相应的table
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/