存储过程（更新选择）

ALTER PROCEDURE [dbo].[updateSelect] AS insert into score (course,studentid,score) values('dfs',3,23) select top 1 * from score order by scoreid desc

 

同下

 

ALTER PROCEDURE [dbo].[updateSelect] AS begin insert into score (course,studentid,score) values('dfs',3,23) end begin select top 1 * from score order by scoreid desc end