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

命犯桃花

Table temp:
ID Product ID time v1 v2 v3 v4 sums

v1--v4 default value 1
sums = v1 + v2 + v3 + v4

Question: When only “Product ID” is entered, the table is automatically completed to get the current system time and sum values

Example: execute the statement insert temp (product ID) values ​​('2001'), and query the table to get:

ID Product ID time v1 v2 v3 v4 sums
1 2001 17:20 1 1 1 1 4

asurae

Just set the default value.
Time: getdate ()
v1: 1
v2: 1
v3: 1
v4: 1
sums: v1 + v2 + v3 + v4

cv4bf5d65fd

Use triggers better

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

zalinzhang

I want to use triggers for auto completion

命犯桃花

Thank youcv4bf5d65fd

asurae

Use triggers better

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

-----------------------------------------------
Where sums = v1 + v2 + v3 + v4, the values ​​of these 4 fields are not entered when input, so this trigger cannot be used

恶魔右指

Just assign 1 to other columns

fanfan1980

create table T (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 as v1 + v2 + v3 + v4
 )

insert T (Product ID) values ​​('2001')

select * from T
--result
id Product ID time v1 v2 v3 v4 sums
----------- ---------- ----- ----------- ------------ --------- ----------- -----------
1 2001 17:22 1 1 1 1 4

(1 row (s) affected)

fanfan1980

Use the default values ​​and calculated columns

命犯桃花

Problem: Execution result