Determine if SQL CMD variable is defined


Simple method to determine if a SQL command variable has been defined.
begin try
	-- do a test to see if this sql cmd variable has been defined.
	IF (N'$(WebServer)' = N'')
	begin
		NoOpTest1:
	end
end try
begin catch
	-- if we had an error, it means the variables have not yet been set.
	-- Set them now.
	:setvar WebServer "www.myserver.com"
	:setvar Environment "live"
end catch


Last modified by Mohit @ 4/5/2025 12:04:29 PM