ALTER PROCEDURE dbo.Get_Simple (
@Question varchar (50)
)AS
/* SET NOCOUNT ON */SELECT top 10 QuestionID,Question
FROM Question
WHERE Question LIKE '%'+@Question+'%'
RETURN
这是我的存储过程,我想搜索到数据库中与Question内容相似的内容显示,但结果会把原Question显示,怎么把它去处,在线等答案!~~
@Question varchar (50)
)AS
/* SET NOCOUNT ON */SELECT top 10 QuestionID,Question
FROM Question
WHERE Question LIKE '%'+@Question+'%'
RETURN
这是我的存储过程,我想搜索到数据库中与Question内容相似的内容显示,但结果会把原Question显示,怎么把它去处,在线等答案!~~
FROM Question
WHERE Question LIKE '%'+@Question+'%'
and question <>@Question --加个条件