setting setvar of sqlcmd dynamically

I have never once used setvar.

DECLARE @forumTable TABLE (value INT, id INT)
INSERT INTO @forumTable (value, id)
VALUES  
(100,1),(200,2),(300,3)

DECLARE @myValue VARCHAR(100)

SET @myValue = (SELECT value FROM @forumTable WHERE id = 2)

SELECT @myValue

SET @myValue = GETDATE()

SELECT @myValue

SET @myValue = @@ServerName

SELECT @myValue

Setting a variables value is done via the SET statement.

http://ift.tt/1C3Bykj