create table test(
pid int,
name varchar(50)
);
insert into test values(2,'a');
select pid as 编号, name as 姓名 from test;-------
create procedure my_produce --------创建存储过程
as
select * from test
go
exec my_produce ----------------调用存储过程