如果域不正确，如何防止创建/更改过程/触发器?我尝试了下面这样的东西，但似乎不起作用

Question

-如果域=x，我不想创建/更改触发器

: ON ERROR EXIT 
USE [DB_Name]
GO

If default_domain()='x'
BEGIN
 RAISERROR (' Preventing deployment in this region. Please ignore the error message',11,1);
 RETURN
END
GO
IF NOT EXISTS (SELECT * FROM sysobjects WHERE type = 'TR' AND name = 'tr_name_insert') 
        EXEC('CREATE TRIGGER [dbo].[tr_name_insert]
ON  [dbo].[table_name]
FOR INSERT
AS
BEGIN
SELECT 1
END')
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[tr_name_insert]
ON  [dbo].table_name
FOR INSERT
.........SOME code
................

Answer 1

这能像语法错误一样简单吗 - : 和 ON ERROR EXIT 之间的空格？

文件应启动

:ON ERROR EXIT 
USE [DB_Name]
GO