贝瓦儿歌app电脑版:急,大家帮忙看下这个存储过程出了什么问题

来源:百度文库 编辑:中科新闻网 时间:2024/03/28 17:52:48
,老是报错@topnum附近有语法错误,存储过程:
CREATE PROCEDURE sp_selSTradeLeadOffer @topnum bigint AS select top @topnum * from Fly_Info where IsPass=1 order by UpdateDate desc

top 后面不能跟变量
改成
CREATE PROCEDURE sp_selSTradeLeadOffer
@topnum bigint
AS
declare @s varchar(100)
set @s='select top '+cast(@topnum as varchar(10))+' * from Fly_Info where IsPass=1 order by UpdateDate desc'
exec(@s)