Hi,
Using SQL 2008 R2
i would create a TSQL SQLCMD Script for Create Storage Procedure. In One SP i have something like:
DELETE FROM dbo.[TableCompanyNameTestVersion$Change Log Entry]
in the Live SQL Version i must change this to:
DELETE FROM dbo.[TableCompanyNameLiveVersion$Change Log Entry]
How can i make this dynamic? So i can use the Script in both Databases?
Or Must I Set this in a Variable ? Like:
:SETVAR TableCompanyName "MyTableName"
Understand you what i mean? (And Sorry my bad english)
Thanks.
Pit