SQLCMD :r where path is a variable

Question

SQLCMD 命令 :r支持非常量文字路径？

例如:

setvar $(path1) '.\script.sql'
:r $(path1) -- SQL01260: A fatal parser error occurred: .
:r '$(path1)' -- SQL01260: A fatal parser error occurred: .
:r "$(path1)" -- SQL01260: A fatal parser error occurred: .

Answer 1

Does the SQLCMD command :r support non-constant literal paths?

确实如此。您以错误的方式定义了变量。尝试:

:setvar path1 "script.sql"
:r $(path1)

另见 this article on MSDN .