We can also concatenete rows using coalesce function, I have given example for that,

Declare @Name as varchar(Max);

with fruit as (

select 'Apple' as name, 101 as id union...

When u declaring local variable at the same statement u can't assign a value

e.g Declare @i as int = 100

it will give error,

u have to declare like

Declare @i as int

set...