Assigning a value to SQL Variable

SQL Server offers two different methods to assign values into variables except for initial value assignment. 

examples:

DECLARE @TestVariable AS VARCHAR(100)

SET @TestVariable = 'contant of variables you need'

PRINT @TestVariable

Out put:

contant of variables you need.

Sign In or Register to comment.