存储过程

create database TestProc
use TestProc

create table users
(
userId int primary key identity(1,1),
userName char(20),
Quantity int default 0,
total int default 0 ,
uId int
)
drop table users

create proc users_proc
@userName char(20),
@Quantity int,
@uId int
as
begin
  insert into users(userName,Quantity,uId) values(@userName,@Quantity,@uId)
end
drop proc users_proc
exec users_proc 'HUA10',200,3



select * from users
select * from total

create table total
(
uId int ,
total int
)


create proc users_proc1
@uId int
as
   declare @total int
   declare @u_Id int
begin
   select @u_Id=uId, @total=sum(Quantity) from users where uId=@uId group by uId
end
begin
   --insert into total(uId,total) values(@u_Id,@total)
    update users set total=@total where uId=@uId
end
begin
select * from users
end

exec users_proc1 1

drop proc users_proc1