Hello, I am new to trigger and I need help to create a trigger that will copy the content from ColumnA and ColumnB into ColumnC. The trigger will fire when Data in ColumnA or ColumnB is: Typed in (new), modified (existing value), delete (value).
In ColumnC there need to be a space and a dash between the content of ColumA and ColumnB
ColumnA = John Denver
ColumnB = Singer
ColumnC = John Denver - Singer
Microsoft SQL Server 2005SQL
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.