How to Print a SQLCMD variable in a database project?

Question

I have a database project for SQL Server 2016. In the project properties, SQLCMD Variables tab:

Variable: $(SOURCE)
Value: MyDB

All I want to do for now is PRINT that variable.

CREATE PROCEDURE [dbo].[usp_Test]
AS
    SET NOCOUNT ON;

    PRINT [$(SOURCE)]

    RETURN 0

The project builds, I do a schema compare, then attempt to update and I get this error:

The name "MyDB" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Is there a way I can print the SQLCMD variables I've set up when running a stored procedure?

OMG... you are right. I had tried PRINT '''' + [$(SOURCE)] + '''' which also failed. But when I just now tried it this way it worked: PRINT '[$(SOURCE)]' THANKS! — Bostaevski
– Bostaevski, Commented Jan 18, 2017 at 17:44

Owain Esau · Accepted Answer · 2017-01-19 05:42:11Z

4

I havent done much with this, but i have the following in one of my scripts and it works fine:

:setvar path "Variable"
PRINT '$(path)'

answered Jan 19, 2017 at 5:42

Owain Esau

1,9222 gold badges23 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tom Cerul Over a year ago

Double quotes to define the variable and single quotes for the print statement! Thank you

Collectives™ on Stack Overflow

How to Print a SQLCMD variable in a database project?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related