1,插入的时候,通过计算后,插入average值 2,在该表上创建一个触发器,插入值之后,更新average的值为平均值CREATE TRIGGER [tr1NAME] ON [dbo].[student] FOR INSERT AS declare @a varchar(100) select @a=sum(cast(english as float)+cast(java as float)+cast(computer as float)+cast(math as float))/4 from student update student set average = @a 这样可以么?
create table tb(english int,java int,computer int,math int,average as (english+java+computer+math)/4)
create table #Tb ( ID int identity(1,1) primary key, english int, . . average default for (Sum(english+java+math+computer)/4) )
直接用update语句就可以了吧。 update student set [average] = (english + java + computer + math)/4 where [average] is not null
数据类型是varchar,
除了id和name,各个字段都是分数么?
2,在该表上创建一个触发器,插入值之后,更新average的值为平均值CREATE TRIGGER [tr1NAME] ON [dbo].[student]
FOR INSERT
AS
declare @a varchar(100)
select @a=sum(cast(english as float)+cast(java as float)+cast(computer as float)+cast(math as float))/4 from student
update student
set average = @a
这样可以么?
create table tb(english int,java int,computer int,math int,average as (english+java+computer+math)/4)
(
ID int identity(1,1) primary key,
english int,
.
.
average default for (Sum(english+java+math+computer)/4)
)
update student
set [average] = (english + java + computer + math)/4
where
[average] is not null