Docstoc

sprocedur

Document Sample
sprocedur Powered By Docstoc
					create procedure pass @examid
as
begin
select * from pass_result where Examid=@examid
exec pass 1




create procedure result @exmid int,@ tname varchar,@marks
int,@eresult,@uname
as
begin
--insert into sale values(@exmid int,@ tname varchar,@marks
int,@eresult,@uname);
--select * from result
--where Exame_id = @exmid
--end

--exec result 1 , 'dbms'   , 10 ,'pass','ahsan'




--create procedure getmarks @Id int ,@marks int output
--as
--begin
--select @marks = Marks from result
--where Exam_id = @ld
--end


--exec getmarks 1

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:1
posted:12/5/2011
language:English
pages:1