.NET中LIKE语句

smpig

于 2012-03-13 11:32:00 发布

阅读量3.3k

点赞数

分类专栏： DataBase 文章标签： .net null string query

本文链接：https://blog.csdn.net/smpig/article/details/7347984

版权

DataBase 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

错误:

string query = @"SELECT gx.GXBM ,

gx.MC ,
gx.QDZC ,
gx.ZDZC ,
gx.GJ ,
gx.BH ,
gx.ZJJ ,
gx.ZJGR ,
gx.ZDYXYL ,
gx.ZXYXYL
FROM dbo.ATB_GXJBXX gx

WHERE @MC is NULL OR gx.MC LIKE '%@MC%'";

正确:

string query = @"SELECT gx.GXBM ,

gx.MC ,
gx.QDZC ,
gx.ZDZC ,
gx.GJ ,
gx.BH ,
gx.ZJJ ,
gx.ZJGR ,
gx.ZDYXYL ,
gx.ZXYXYL
FROM dbo.ATB_GXJBXX gx
WHERE @MC is NULL OR gx.MC LIKE '%'+@MC+'%'";

分析:错误写法导致参数无法识别.

SQL Profilter对比:

错误:

exec sp_executesql N'SELECT gx.GXBM ,
gx.MC ,
gx.QDZC ,
gx.ZDZC ,
gx.GJ ,
gx.BH ,
gx.ZJJ ,
gx.ZJGR ,
gx.ZDYXYL ,
gx.ZXYXYL
FROM dbo.ATB_GXJBXX gx
WHERE @MC is NULL OR gx.MC LIKE ''%@MC%''',N'@MC nvarchar(1)',@MC=N'石'

正确:

exec sp_executesql N'SELECT gx.GXBM ,
gx.MC ,
gx.QDZC ,
gx.ZDZC ,
gx.GJ ,
gx.BH ,
gx.ZJJ ,
gx.ZJGR ,
gx.ZDYXYL ,
gx.ZXYXYL
FROM dbo.ATB_GXJBXX gx
WHERE @MC is NULL OR gx.MC LIKE ''%''+@MC+''%''',N'@MC nvarchar(1)',@MC=N'石'