實(shí)例：

create procedure getStatusCompanyExample

@statusValue int,
@CompanyName nvarchar(50)
AS
BEGIN
select *from IKCExamples.dbo.IKCExamples as A,IKCExamples.dbo.Examples as B,IKCUser.dbo.userinfo as C
where A.id=B.exampleid and B.status=@statusValue? and A.userid=C.userid? and C.company_name=@CompanyName

END

需要注意的就是在參數(shù)類型確定上一定要和，要與之匹配的列的屬性相一致就好