SQLite TRIGGER to SQL server conversion.

Question

What would the SQL server version of the following. Is there an SQL server conversion for the NEW command. Do I have to JOIN the widgetSale table?

CREATE TRIGGER newWidgetSale
ON widgetSale
AFTER INSERT
AS
BEGIN
UPDATE widgetCustomer SET last_order_id = NEW.id WHERE widgetCustomer.id = NEW.customer_id
END

Answer 1

SQL Server uses tables INSERTED/DELETED in triggers.

See:
https://learn.microsoft.com/en-us/sql/relational-databases/triggers/use-the-inserted-and-deleted-tables?view=sql-server-ver16
https://www.mssqltips.com/sqlservertip/2342/understanding-sql-server-inserted-and-deleted-tables-for-dml-triggers/

UPDATE wc  
	SET last_order_id = NEW.id   
FROM widgetCustomer wc  
	INNER JOIN INSERTED NEW   
	ON widgetCustomer.id = NEW.customer_id