Set temp macro from result of Run SQL action
Hello,
I have a need to set a local variable macro based on if the database exists or not.
I have the following query in "Run SQL" action.
if db_id('%CurrentDatabaseName%') is null
BEGIN
-- ???? STEP TO set local variable which effectively says 'NO DB'
END
How can I achieve this?
Thanks!
|