create proc usp_AAInvoiceManagement_Search @InvoiceNo nvarchar (20), @PayDate smalldatetime, @FactoryName nvarchar(60) as select * from AAInvoiceManagement where rtrim(InvoiceNo)=@InvoiceNo and PayDate=@PayDate and FactoryName=@FactoryName order by invoiceno goexec usp_AAInvoiceManagement_Search N'0508001','2002-5-5',N'深圳市华茂实业发展有限公司'
@InvoiceNo nvarchar (20),
@PayDate smalldatetime,
@FactoryName nvarchar(60)
as
select * from AAInvoiceManagement
where rtrim(InvoiceNo)=@InvoiceNo and
PayDate=@PayDate and
FactoryName=@FactoryName
order by invoiceno
goexec usp_AAInvoiceManagement_Search N'0508001','2002-5-5',N'深圳市华茂实业发展有限公司'