Temp Table Vs  Table Variable 

**      Temp Table has the scope only within the transaction

**      Table Varible has the scope within that current session

BEGIN TRAN

declare @var table (id int, data varchar(20) )

create table #temp (id int, data varchar(20) )

insert into @var

select 1, 'data 1' union all

select 2, 'data 2' union all

select 3, 'data 3'

insert into #temp

select 1, 'data 1' union all

select 2, 'data 2' union all

select 3, 'data 3'

select * from #temp

select * from @var

ROLLBACK

select * from @var

if object_id('tempdb..#temp') is null

    select '#temp does not exist outside the transaction'

SQL SELECT To HTML MAIL

--SQL SELECT  To HTML MAIL DECLARE @to varchar(max)
DECLARE @sub varchar(max)
DECLARE @body nvarchar(max)       
DECLARE @return varchar(2)=char(13)
DECLARE @cc varchar(max)
Declare @resolution varchar(max)
Declare @vtableHTML as varchar(max)
SET @vtableHTML =          
N'<H1> Medall HR-Task '+ CONVERT(VARCHAR(9), GETDATE(), 6)   + ' </H1>'+          
N'<table border="1">' +          
N'<tr width=100pixcel><th>TASK NAME</th>' +
N'<th>TASK DESCRIPTION</th>' +            
N'<th>PROJECT</th>' +          
N'<th>PRIORITY</th>' +          
N'<th>ASSIGNED BY</th>' +          
N'<th>START DATE</th><th>END DATE</th>' +          
N'<th>STATUS      </th>' +          
N'<th>REPETITIVE</th>'+  
N'<th>RESOLUTION</th>'+           
CAST (( SELECT td = T.TASK_NAME, '',          
 td = TASK_DESC, '',          
 td = project_name, '',          
 td = priority_desc, '',          
 td = EMPLOYEE_NAME, '',          
 td = CONVERT(VARCHAR(11),START_DATE,106), '',          
 td = CONVERT(VARCHAR(11),DUE_DATE,106), '',          
 td = status, '',          
 td = case when repetitive=1 then 'YES' else 'NO' end  , '',          
 td = resolution , ''
--select *
FROM TASKS
WHERE TASK_ID=2
      FOR XML PATH('tr'), TYPE  ) AS NVARCHAR(MAX) ) + N'</table>' ;   
--SELECT @vtableHTML
  EXEC MSDB.DBO.SP_SEND_DBMAIL   

  --@PROFILE_NAME = 'TEST', 

@RECIPIENTS=@TO, 
@SUBJECT = 'TASK' ,   
@copy_recipients =@CC,
@BODY = @vtableHTML, 
@body_format     ='HTML'