Create HTML table in SQL server

 EXECUTE RED CODE  TO GET OUTPUT:

DECLARE @htmlTable varchar(1000)= '<table cellpadding=0 cellspacing=0 border=0>'
SET @htmlTable += 
  CAST(
    (SELECT
      'Column1' AS td, '',
      'Column2' AS td, '',
      'right' AS [td/@align], 'Column3' AS td, ''
    FOR XML PATH('tr')) AS VARCHAR(1000)
  )

SET @htmlTable += '</table>'

SELECT @htmlTable 


OUTPUT WILL BE :

<table cellpadding="0" cellspacing="0" border="0">
            <tr>
                <td>
                    Column1
                </td>
                <td>
                    Column2
                </td>
                <td align="right">
                    Column3
                </td>
            </tr>
</table>