存储过程中如何动态选出top几条的记录
存储过程中如何动态选出top几条的记录,其中top几条的具体值由外部传进来
[解决办法]
ALTER PROCEDURE QueryRecordByOne
@Num int
AS
exec ( 'select top ' + @Num + ' * from RecordManager order by StartTime asc ')
RETURN
发布时间: 2012-03-03 15:33:03 作者: rapoo
存储过程中如何动态选出top几条的记录
存储过程中如何动态选出top几条的记录,其中top几条的具体值由外部传进来
[解决办法]
ALTER PROCEDURE QueryRecordByOne
@Num int
AS
exec ( 'select top ' + @Num + ' * from RecordManager order by StartTime asc ')
RETURN