存储过程返回一个结果集

[yuanetking]

如何用Tran-sql 设计存储过程并且返回一个结果集，请问代码怎么写？大体的。谢谢

[iswear428]

CREATE PROCEDURE dbo.YOUPRO
@TYPE varchar(9)
AS
SELECT ID,NAME,SEX ,TYPE
FROM YOUTABLE
WHERE TYPE=@TYPE
ORDER BY ID

GO

[venket]

e.g
create proc res
@table varchar(20)
as
select count(*) 结果集 from @table

[daijingjie2002]

create proc p
as
select * from item

返回一个表
create proc p
@s varchar(10)
as
select * from item where item_no=@s
传递参数进去，再返回表

[xluzhong]

create procedure 存储过程名称
@type varcahr(10) -----输入参数
as
----
select *
from tablename
where type=@type
----sql语句
go

[dick_lee]

记住好像存储过程里没有for循环的，有while.

[dick_lee]

注解是用/*或--