ALTER PROCEDURE [dbo].[GetPayDetail]
@OrgCode NVARCHAR(255),
@CardNo NVARCHAR(19),
@BeginDate CHAR(8),
@EndDate CHAR(8),
@SRN CHAR(12),
@RepayFlag CHAR(1)
AS
BEGIN
SET NOCOUNT ON; SELECT PayDetail.*, CardInfo.CardholderName
FROM PayDetail
INNER JOIN CardInfo ON CardInfo.OfficialCardNo = PayDetail.CardNo AND CardInfo.CanRepay = 1
INNER JOIN Orgs ON CardInfo.OrgCode = Orgs.OrgCode
WHERE Orgs.OrgCode=@OrgCode
AND (@CardNo IS NULL OR PayDetail.CardNo = @CardNo)
AND (@BeginDate IS NULL OR PayDetail.AccountingDate >= @BeginDate)
AND (@EndDate IS NULL OR PayDetail.AccountingDate <= @EndDate)
AND (@SRN IS NULL OR PayDetail.SRN like'%'+@SRN) //这里
AND (@RepayFlag IS NULL OR PayDetail.RepayFlag = @RepayFlag)我这里 like'%'+@SRN 模糊匹配后4位为什么匹配不了?
@OrgCode NVARCHAR(255),
@CardNo NVARCHAR(19),
@BeginDate CHAR(8),
@EndDate CHAR(8),
@SRN CHAR(12),
@RepayFlag CHAR(1)
AS
BEGIN
SET NOCOUNT ON; SELECT PayDetail.*, CardInfo.CardholderName
FROM PayDetail
INNER JOIN CardInfo ON CardInfo.OfficialCardNo = PayDetail.CardNo AND CardInfo.CanRepay = 1
INNER JOIN Orgs ON CardInfo.OrgCode = Orgs.OrgCode
WHERE Orgs.OrgCode=@OrgCode
AND (@CardNo IS NULL OR PayDetail.CardNo = @CardNo)
AND (@BeginDate IS NULL OR PayDetail.AccountingDate >= @BeginDate)
AND (@EndDate IS NULL OR PayDetail.AccountingDate <= @EndDate)
AND (@SRN IS NULL OR PayDetail.SRN like'%'+@SRN) //这里
AND (@RepayFlag IS NULL OR PayDetail.RepayFlag = @RepayFlag)我这里 like'%'+@SRN 模糊匹配后4位为什么匹配不了?
解决方案 »
- 如何通过textbox来改变另一个空间的最大最小值
- C++怎么调用C#的DLL
- 读取C:\Documents and Settings\Administrator\Local Settings\Temporary Internet Files的内容
- oracle 基础问题 在线等。。。 急。请高手帮忙。
- c# 开发的 winform 程序运行时特慢,得等半天,怎么解决?
- vs2005,新建C# Office项目,提示"无法安装该项目所需的主互操作程序。将不会创建该项目。要创建项目,请手动安装主互操作程序集"
- winform 中DataGrid 修改多行 后怎么一起提交所有的数据
- 求教,那里有开发安装项目的资料?
- 在GRIDVIEW中点击表中指定字段能够跳转到另外一页
- 在C#里如何操纵Excel实现数据输出
- asp.net关于一个多线程的问题,
- C# treeview如何单击节点后,右边显示窗体
like '%后四位%'