Triggers in Sql Express Edition

Question

User1979860870 posted

Hi

 How to create Triggers in Sql 2014 express edition

Thanks

Answer 1

User475983607 posted

How to create Triggers in Sql 2014 express edition

See the standard docs for syntax and code examples.

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver15

If you are having trouble explain the problem.

Answer 2

User1535942433 posted

Hi jagjit saini,

As far as I think,you could use this to create trigger:

CREATE TRIGGER [schema_name.]trigger_name
ON table_name
AFTER  {[INSERT],[UPDATE],[DELETE]}
[NOT FOR REPLICATION]
AS
{sql_statements}

More details,you could refer to below article:

https://www.sqlservertutorial.net/sql-server-triggers/sql-server-create-trigger/

Best regards,

Yijing Sun