UC知道sql存储过程问题
来源：百度知道 编辑：UC知道 时间：2024/05/12 03:26:27
CREATE PROCEDURE dbo.SIFA_GetIndexArticleList
(
@p_dirid int,
@p_num int
)
AS
select top @p_num * --这里出错，请问怎么实现此功能？
from Picc_Article
where idel='F' and dirid=@p_dirid
order by publishtime desc
GO
(
@p_dirid int,
@p_num int
)
AS
select top @p_num * --这里出错，请问怎么实现此功能？
from Picc_Article
where idel='F' and dirid=@p_dirid
order by publishtime desc
GO
CREATE PROCEDURE dbo.SIFA_GetIndexArticleList
(
@p_dirid int,
@p_num int
)
AS
declare @str varchar(4000)
set @str='select top '+cast(@p_num as varchar(10))+' * from Picc_Article where idel='F' and dirid='+cast(@p_dirid as varchar(10))+' order by publishtime desc'
exec(@str)
GO