sql-server - 设置 NOEXEC ON 仍然执行 "USE"语句

Question

在 SSMS 中执行以下操作时；

if not exists (select * from sys.databases where name = 'SWFUAT')
begin
    print 'The UAT database (SWFUAT) does not exist...'
    set noexec on;
end
go

use SWFUAT;
go

显示如下；

The UAT database (SWFUAT) does not exist...
Msg 911, Level 16, State 1, Line 20
Database 'SWFUAT' does not exist. Make sure that the name is entered correctly.

编译器不应该忽略“use”语句吗？

Answer 1

如果我正确理解你的问题那么你想执行

use SWFUAT;

仅当SWFUAT 数据库存在时。

不幸的是因为这句话

USE is executed at both compile and execution time and takes effect immediately. Therefore, statements that appear in a batch after the USE statement are executed in the specified database.

描述 here你不能简单地在你的情况下使用 SET NOEXEC 。为了实现你所需要的，你应该用例如这个替换你的代码

if not exists (select * from sys.databases where name = 'SWFUAT')
begin
    print 'The UAT database (SWFUAT) does not exist...' 
end else begin
    use SWFUAT;
end
go