34,876
社区成员
发帖
与我相关
我的任务
分享想做个根据参数出第查询记录条数的过程，调试总通不过，请大家指教。
以下存储为什么不能通过语法检测啊？
Create PROCEDURE dbo.SP_CommendFood
@count int
AS
select top @count *
from TBL_Carte
order by i_DishCommend DESC
Create PROCEDURE dbo.SP_CommendFood
@count int
AS
select top @count *
from TBL_Carte
order by i_DishCommend DESC
...全文
请发表友善的回复…
发表回复
lxhvc 2005-03-13
- 打赏
- 举报
多谢指教。
xluzhong 2005-03-13
- 打赏
- 举报
Create PROCEDURE dbo.SP_CommendFood
@count int
AS
exec('select top '+@count+' *
from TBL_Carte
order by i_DishCommend DESC')
@count int
AS
exec('select top '+@count+' *
from TBL_Carte
order by i_DishCommend DESC')
xluzhong 2005-03-13
- 打赏
- 举报
Create PROCEDURE dbo.SP_CommendFood
@count int
AS
exec('select top '+@count+' *
from TBL_Carte
order by i_DishCommend DESC')
@count int
AS
exec('select top '+@count+' *
from TBL_Carte
order by i_DishCommend DESC')
