set sql variable code example

Example 1: sql declare variable

-- Declare the variable to be used.
DECLARE @MyCounter int;

-- Initialize the variable.
SET @MyCounter = 0;

Example 2: sql server: how to assign value to table variable returned from function

INSERT INTO @tableVariableName
SELECT * FROM <schemaName>.<functionName>([@parameters_names, ..])