I have a database that I created in SQLite, and I need to convert it over to MS SQL server environment. When I execute the attached code there were several errors, which I corrected. However I am unable to get the equivalent syntax for the attached Trigger as I keep getting the following error message:
"Msg 111, Level 15, State 1, Line 384
'CREATE TRIGGER' must be the first statement in a query batch."
I am not sure how to write this for SQL server, so it would be greatly appreciated if someone correct this line, as there are several triggers that need to be created.