create procedure gtname(@name varchar(10) output)
as
select @name from 学生表 where 姓名=@name
use tempdb
go
create proc p_test
@id int output
as
set @id = @id + 1
go
declare @id int
set @id = 1
exec p_test @id output
select @id
go
drop proc p_test
go
