主页 / dba / 问题 / 144304
Accepted
Muflix
Asked: 2016-07-20 03:32:29 +0800 CST

SQLCMD 在 sql 项目的预部署脚本中不起作用

  • 772

我在 visual studio 中有 sql 项目，我创建了预部署脚本

/*
 Pre-Deployment Script Template                         
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be executed before the build script.   
 Use SQLCMD syntax to include a file in the pre-deployment script.          
 Example:      :r .\myfile.sql                              
 Use SQLCMD syntax to reference a variable in the pre-deployment script.        
 Example:      :setvar TableName MyTable                            
               SELECT * FROM [$(TableName)]                 
--------------------------------------------------------------------------------------
*/

:setvar TableName MyTable                           
SELECT * FROM [$(TableName)]

:setvar但我在线上遇到错误

Incorrect syntax near ':'.

我错过了什么？

sql-server-2008 visual-studio-2012

1 个回答

  1. Best Answer

    社区维基答案：

    您需要通过菜单SQL > Execution SettingsSQLCMD切换到Visual Studio 模式。

    SQLCMD mode如果您深入了解Options > SQL Server Tools > Query Execution ，您还可以默认打开所有 SQL 文件。

    • 1

相关问题