【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了CreateTestProcedure1.sql相关资料,希望对各位网友有所帮助!
Create Procedure TestProcedure1
(
@au_idIN varchar (11)
)
As
select count (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
Return(5)