具有“+”字段的字段内容符号不会返回查询的任何结果 [英] Field content with "+" symbols does not return any results from query
本文介绍了具有“+”字段的字段内容符号不会返回查询的任何结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
名称的字段内容示例:
- TST30 L200 HI PowerPlus Act TC V 1.pgm
- TST30 L200 HI Power + Act TC V 1.pgm< ==无法查询
查询样本:
- EXEC @return_value = [dbo]。[sp_GetProgramFileByName] @Name = N'TST30 L200 HI PowerPlus Act TC V 1.PGM',@ Family = NULL
- EXEC @return_value = [dbo]。[ sp_GetProgramFileByName] @Name = N'TST30 L200 HI Power + Act TC V 1.PGM',@ Family = NULL < ==无法查询
存储过程:
ALTER PROCEDURE [dbo]。[sp_GetProgramFileByName]
(
; @Name AS varchar(50)= null
,@ Family AS varchar(50)= null
)
(
; @Name AS varchar(50)= null
,@ Family AS varchar(50)= null
)
ALTER PROCEDURE [dbo].[sp_GetProgramFileByName]
(
@Name AS varchar(50) = null
,@Family AS varchar(50) = null
)
(
@Name AS varchar(50) = null
,@Family AS varchar(50) = null
)
推荐答案
这不是查询,而是执行存储过程"sp_GetProgramFileByName"。如果不知道它的SQL代码,我们甚至可以猜出问题是什么。
That are not queries, it's execution of a stored procedure "sp_GetProgramFileByName" and without knowing the SQL code of it we even can guess what the issue may is.
这篇关于具有“+”字段的字段内容符号不会返回查询的任何结果的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文