Novice seeking a SQL stored procedure (online, etc ...)

命犯桃花

Server: Message 286, level 16, state 1, procedure auto_update, line 4
The logical tables INSERTED and DELETED cannot be updated.

cv4bf5d65fd

create table temp (ID int, product ID int, time datetime, v1 int, v2 int, v3 int, v4 int, sums int)




create trigger auto_update on temp
for insert
as
   update a set a. time = getdate (), a.sums = a.v1 + a.v2 + a.v3 + a.v4 from temp a, inserted b where a. product ID = b. product ID


insert temp (Product ID) values ​​(2001)

select * from temp

菜鸟明星

create table Tt (
id int identity,
Product ID varchar (10),
Time char (5) default convert (char (5), getdate (), 108),
v1 int default 1,
v2 int default 1,
v3 int default 1,
v4 int default 1,
sums int default 4
 )

命犯桃花

Thank you, the problem has been solved