如何在SQL Server中显示根据条件插入数据的消息结果？

-- 创建一个示例表
CREATE TABLE ExampleTable (
    ID INT PRIMARY KEY,
    Name VARCHAR(50)
);

-- 定义要插入的数据
DECLARE @ID INT = 1;
DECLARE @Name VARCHAR(50) = 'John';

-- 插入数据并根据条件显示消息结果
IF NOT EXISTS (SELECT * FROM ExampleTable WHERE ID = @ID)
BEGIN
    INSERT INTO ExampleTable (ID, Name)
    VALUES (@ID, @Name);
    SELECT '数据插入成功' AS Result;
END
ELSE
BEGIN
    SELECT '数据插入失败，ID已存在' AS Result;
END