Q4hV4M63

1CREATE TABLE IF NOT EXISTS asd (n INT DEFAULT (SELECT COUNT(id) FROM users));
2	
3IF OBJECT_ID('TRG_InsertUpdSales') IS NOT NULL
4DROP TRIGGER TRG_InsertUpdSales
5GO
6
7CREATE TRIGGER TRG_InsertUpdSales
8ON dbo.Table2
9AFTER INSERT AS
10BEGIN
11UPDATE Table1 set sales=sum(column1) from Table2 where Table1.user=Table2.user
12SELECT * FROM INSERTED
13END
14GO