有关存储过程 的问题

Question

数据类型不对
改为,ALTER PROCEDURE NewsSearch
@NewsSearch varchar(6000) AS
select
  NewsID,Title
from
  News
where
 Title like '%@NewsSearch%'

Answer 1

ALTER PROCEDURE NewsSearch
@NewsSearch text
AS
select
  NewsID,Title
from
  News
where
 Title like '%'+@NewsSearch+'%'

Answer 2

ALTER PROCEDURE NewsSearch
@NewsSearch text
AS
select
  NewsID,Title
from
  News
where
 Title like '%'+@NewsSearch+'%'