|
ALTER PROCEDURE dbo.InvDetail_SL_ACNO
(@cocode nvarchar(50),
@mattype nvarchar(50),
@supplierid nvarchar(50),
@sl_app as tinyint) as
if @sl_app=1
SELECT CoCode, MatType, SupplierID, InvPeriod, DueDate, Currency, Discount, Amount,
IssueDate, Urgent, ChqNo, FinRecDate, PayApp, PayBy, PayType, IssuedBank,
ChqDate,expir
FROM dbo.InvoiceDetail
WHERE (ChqNo IS NULL) AND (payapp=0) and (CoCode = @cocode) AND (MatType = @mattype) AND
(SupplierID = @supplierid)
ORDER BY CoCode, MatType, SupplierID, InvPeriod
else
if @sl_app=2
時,我怎樣才能屏蔽當中一個參數,如@cocode不作用,而另兩個就可作用,再而又一個IF之後又可以屏多一個參數呢。
謝謝各位大哥先![em07] |
|