我写的这么简单的存储过程，怎么总是查询不到数据呀。

[fengling181]

CREATE PROCEDURE FindNews
@news_type varchar(20),
@news_content varchar(50)
AS
begin
select * from net_news where @news_type like '%'+@news_content+'%'
end
GO

[fengling181]

帮帮忙呀····

[aierong]

CREATE PROCEDURE FindNews
@news_type nvarchar(20),
@news_content nvarchar(50)
AS
declare @sql nvarchar(4000)
select @sql='select * from net_news where '+@news_type +' like ''' +'%'+@news_content+'%'''
exec sp_executesql @sql

[chinamnli]

select * from net_news where @news_type like '%'+@news_content+'%'


改为：select * from net_news where @news_type like '%@news_content%'

[伍子V5]

CREATE PROCEDURE FindNews
@news_type varchar(20),
@news_content varchar(50)
AS
begin
exec 'select * from net_news where '+@news_type+' like ''%'+@news_content+'%'''
end
GO

[nforcedzh]

如果在编译时还不能确定SQl语句，就必须用动态SQL语句
同意
aierong(皑婀瑢-数据库XML.NET联盟会科长)

[yujohny]

CREATE PROCEDURE FindNews
@news_type varchar(20),
@news_content varchar(50)
AS
begin
select * from net_news where @news_type like '''%'+@news_content+'%'''
end
GO

[fengling181]

讲讲为什么要这么用好吗？原理

[aierong]

to:fengling181(斑马线)

在语句里面

''---'

[aierong]

刚才升级啦

现在是处长啦

[skm]

sp_executesql N'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'

[zxmout]

sql中怎么还有begin，end,go呀？

是标准语句吗？我学习的时候怎么没有学过呀？

还有@是什么意思呀？