Forum Discussion
Solved
Error when trying to create a Trigger
Hi I am trying to create a trigger so when a value changes from null to a value it copies the value into another field. However, I am getting errors on the basic code like BEFORE. Any ideas wh...
Hi
I managed to resolve the issue. I think it was because the code I was using was mySQL and when I converted it to TSQL it works.
Thanks for trying to help.
Aaron
Check out the SQL Server syntax of Trigger https://learn.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver16