在SSDT项目中(使用VS2017 / VS2015,SSDT版本15.1.61702.140),我无法使我的项目构建。编译器一直抱怨我的PostDeploymentScript中的SQL语句(是的,我已将BuildAction属性设置为PostDeploy)。这个SQL语句是:
if ('$(env)' = 'dvp')
BEGIN
PRINT 'creating users for dvp'
:r .\SecurityAdditions\usersdvp.sql
END
ELSE IF ('$(env)' = 'qat')
BEGIN
PRINT 'creating users for qat'
:r .\SecurityAdditions\usersqat.sql
END
实际错误信息是:
D:\My\File\Path\PostDeploymentScript.sql (lineNum, col): Error: SQL72007:
The syntax check failed 'Unexpected end of file occurred.' in the batch near:
错误消息中最后一行(end)提到的行号。有任何想法是什么导致了这个错误?