I am wanting to send db_mail when my field 'Status' changes value.
My trigger is as below
create TRIGGER [dbo].[SupportCallEmail]
@profile_name = 'SMTPPROFILE', -- Get this value from Server configuration
@recipients = 'SUPPORT@COMPANY.COM',
@subject = 'Change in Record Statsus',
@body = 'status updated'
The trigger does work but seems to work on any field change, not just the 'Status' field
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple. The final solution for this task involved creating a custom text parser and then reading…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…