CSS Design in SQL Server Stored Procedure

Question

Dear Team,
I have a SQL Server Database. In that, I have a stored procedure.
That is a job/schedular.
This runs every morning at 10.00am and it sends mail to higher authority daily.
Issue - There is a requirement that we need to make this mail look more attractive.
So, I need to add design templates (.css files, fonts files, jquery files) in this stored procedure.
So that, the colours are applied on table headers and rows, etc and everywhere on mail.
Please guide - How do we apply css files in SQL Server.
Please help as it is very urgent and imp..

rajendra singh · Answer

When you are applying loop on data you can add style on html elements (table,tr,td). Beacuase at the end you willl have to send html data in email content.

Riddhi Valecha · Answer

Hi,

I saw the link. It has css-styles inside a variable - @Style nvarchar(max).

This is for less/small data.

In my database stored procedure, I have 5 tables (5 select queries) with different headings and different number of columns and rows.

I also need to have one main heading.

And I have 2 .css files with multiple class.

I need to set the .css classes to each select query.

The way we used to do in asp.net (.aspx page) - CssClass="csstable" .

How do I do that ?

rajendra singh · Answer

Hello Mam,   I think  you need to send html email by putting inline css or you can store html file on your server and replace the content accordingly and send the updated content to email.   Please refer   https://www.sqlshack.com/format-dbmail-with-html-and-css/   Thanks