【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-CreateTestProcedure.sql,希望本篇文章对您学习有所帮助。
Create Procedure TestProcedure
(
@au_idIN varchar (11),
@numTitlesOUT Integer OUTPUT
)
As
select A.au_fname, A.au_lname, T.title
from authors as A join titleauthor as TA on
A.au_id=TA.au_id
join titles as T
on T.title_id=TA.title_id
where A.au_id=@au_idIN
set @numTitlesOUT = @@Rowcount
return (5)