错误:
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+'%'";
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'石'