DECLARE @s1 varchar(40); SET @s1 = 'Learn T-SQL '; SET @s1 += 'with Simple Samples.'; PRINT @s1; ---- output Learn T-SQL with Simple Samples. SELECT (Name + ', ' + Country) AS Name FROM EMP where Salary = 6000 ---- output Vijay, India