create procedure pro_foundid 
        @fid varchar(4)
as 
select * from MemberData where [ID]=@fid


create procedure pro_outcount
	@count int output
as
	select @count= (select count(*) from MemberData)
CREATE PROCEDURE find_member AS
select * from memberdata
GO

create procedure pro_all
	@count	int output
as	
	select * from memberdata
	select @count= (select count(*) from MemberData)