Need help to create a sql trigger code to send an email to firstname.lastname@example.org with subject heading "New SCAR <number> (whatever this new number is after insert) generated" and message of the body is "The SCAR is for <AreaRequiringCA>
<number> is the SCAR_No field value for a new insert and <AreaRequringCA> is a ntext in design.
So I would like the message to go only after an insert of a new SCAR_No has been created and the <AreaRequirintgCA> goes from null to some ntext value. The table is called "SCARLogCopy"
No idea how to do this. This email will occur like once in two weeks at most.