SQL Server ':setvar' 错误 [英] SQL Server ':setvar' Error

问题描述

我正在尝试在 T-SQL 中创建一些脚本变量，如下所示:

I am trying to create some script variables in T-SQL as follows:

    /*
    Deployment script for MesProduction_Preloaded_KLM_MesSap
    */

    GO
    SET ANSI_NULLS, ANSI_PADDING, ANSI_WARNINGS, ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER ON;

    SET NUMERIC_ROUNDABORT OFF;


    GO
    :setvar DatabaseName "MesProduction_Preloaded_KLM_MesSap"

但是，当我运行它时，我收到一条错误消息，指出':'附近的语法不正确."我做错了什么?

However, when I run this, I get an error stating 'Incorrect syntax near ':'. What am I doing wrong?

推荐答案

:setvar 仅适用于 SQL 命令模式，因此您可能在 management studio 中正常执行 SQL 并且尚未切换到命令模式.

The :setvar only works in SQL command mode, so you are possibly within normal SQL execution in the management studio and have not swapped to command mode.

这可以通过 SQL Server Management Studio 中的用户界面通过转到查询"菜单并选择SQLCMD 模式"来完成.

This can be done through the user interface in SQL Server Management Studio by going to the "Query" menu, and selecting "SQLCMD mode."

这篇关于SQL Server ':setvar' 错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！