i have script - config.sql:
if '$(envname)' = 'env1' -- call 'dostuff.sql' , pass in data, 'envname = env1' in dostuff.sql:
-- want define/accept parameters set envname = @envname - inbound data - no idea syntax should i know super fundamental can't seem find examples. possible?
tried write comment seems don't have enough points that...
anyhow, based on excerpt provided take use sqlcmd run sql scripts. if case can use -v switch define parameter want pass execution.
for further information, please have @ sqlcmd syntax in sqlcmd utility , use sqlcmd scripting variables
