Does Azure SQL supports INSTEAD OF trigger?

Question

Does Azure SQL(PaaS offering) supports INSTEAD OF trigger? If yes, it would be helpful if you can demonstrate it for me.

Thanking you in advance.

Answer 1

Yes, it's supported, see
https://learn.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver16
=> Azure SQL Database Syntax

If yes, it would be helpful if you can demonstrate it for me.

See section "Examples" in the article.