if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[uspGetBillDetails]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[uspGetBillDetails]gocreate proc uspGetBillDetails
(
@billCode varchar(10) --票据编码
@BillType int, --票据类型
@billStatus int, --票据状态
@beginWriteDate datetime, --开始填写日期
@EndWriteDate datetime, --结束填写日期
@recordCount int=0 output--输出参数)asset nocount onselect
BillCode, --票据编号
BillState, --票据状态
WriteDate, --填写日期
AcceptStation --接货点
from BillMgt_BillDetail
where BillCode=@billCode and
WriteDate>=@beginWriteDate and WriteDate<=@EndWriteDate --等等select @recordCount=@@rowcount--或者直接使用return 返回
--return @@rowcountset nocount off
drop procedure [dbo].[uspGetBillDetails]gocreate proc uspGetBillDetails
(
@billCode varchar(10) --票据编码
@BillType int, --票据类型
@billStatus int, --票据状态
@beginWriteDate datetime, --开始填写日期
@EndWriteDate datetime, --结束填写日期
@recordCount int=0 output--输出参数)asset nocount onselect
BillCode, --票据编号
BillState, --票据状态
WriteDate, --填写日期
AcceptStation --接货点
from BillMgt_BillDetail
where BillCode=@billCode and
WriteDate>=@beginWriteDate and WriteDate<=@EndWriteDate --等等select @recordCount=@@rowcount--或者直接使用return 返回
--return @@rowcountset nocount off
--try
create proc uspGetBillDetails
@billCode nvarchar(200), --票据编码
@BillType nvarchar(200), --票据类型
@billStatus nvarchar(200), --票据状态
@beginWriteDate datetime, --开始填写日期
@EndWriteDate datetime, --结束填写日期
@recordCount int output
as
begin
select @recordCount = count(1) from BillMgt_BillDetail
where charindex(BillCode,isnull(@billCode,BillCode))>0 and
charindex(BillType,isnull(@BillType,BillType))>0 and
WriteDate between isnull(@beginWriteDate,WriteDate) and isnull(@EndWriteDate,WriteDate) select BillType,BillCode,BillState,WriteDate,AcceptStation from BillMgt_BillDetail
where charindex(BillCode,isnull(@billCode,BillCode))>0 and
charindex(BillType,isnull(@BillType,BillType))>0 and
WriteDate between isnull(@beginWriteDate,WriteDate) and isnull(@EndWriteDate,WriteDate)end
go
CREATE PROCEDURE GetBillDetails
(
@billCode VARCAHR(20), --票据编码
@BillType VARCAHR(20), --票据类型
@billStatus VARCAHR(20), --票据状态
@beginWriteDate DATETIME, --开始填写日期
@EndWriteDate DATETIME,--结束填写日期
@recordCount INT OUTPUT
)
.
.
.
.
SET @recordCount=.....
SELECT @recordCount --也可以不用,可以在调整用调整过程后再 SELECT