--? create proc p_1 as update tb set num=your_val where ...... select name from tb where ... go
--? create proc p_1(@val varchar(20)) as update tb set num=@val where ... select name from tb where ... go
--参考 适用2005以后版本update score set score=a.score+isnull(b.score,0) output deleted.user_game_id, deleted.score score_old, inserted.score score_new into score_history(user_game_id,score_old,score_new) from score a inner join pcbar_ss_session_history_score b on a.user_game_id=b.user_game_id
--?
create proc p_1
as
update tb
set num=your_val
where ......
select name from tb where ...
go
--?
create proc p_1(@val varchar(20))
as
update tb
set num=@val
where ...
select name from tb where ...
go
score
set
score=a.score+isnull(b.score,0)
output
deleted.user_game_id,
deleted.score score_old,
inserted.score score_new into score_history(user_game_id,score_old,score_new)
from
score a
inner join
pcbar_ss_session_history_score b
on a.user_game_id=b.user_game_id