2,498
社区成员
发帖
与我相关
我的任务
分享在delphi中如何从SQLSERVER数据库取出想要行数的结果集
本人在DELPHI中访问数据库，在SQLSERVER中编写一个简单的存储过程如下：
CREATE PROCEDURE PROC_GET_Alarm_INFO
(@Num int)
AS
Select top @NUM * From TBL_Fault_Alarm where (DISPLAYED <> 1 and TREATED <>1) ORDER BY OCCUR_TIME DESC,FAULT_LEVEL
GO
本意是想通过接收传过来的NUM变量的值来决定所取的行数但是语法检查都过不去，望各位高手指点
CREATE PROCEDURE PROC_GET_Alarm_INFO
(@Num int)
AS
Select top @NUM * From TBL_Fault_Alarm where (DISPLAYED <> 1 and TREATED <>1) ORDER BY OCCUR_TIME DESC,FAULT_LEVEL
GO
本意是想通过接收传过来的NUM变量的值来决定所取的行数但是语法检查都过不去，望各位高手指点
...全文
请发表友善的回复…
发表回复
gengxuyong 2004-08-26
- 打赏
- 举报
谢谢楼上的:)
lovewhat1234 2004-08-26
- 打赏
- 举报
CREATE PROCEDURE PROC_GET_Alarm_INFO
(@Num varchar(10))
AS
declare @sqlstring varchar(5000)
set @sqlstring='Select top '+@NUM+' * From TBL_Fault_Alarm where (DISPLAYED <> 1 and TREATED <>1) ORDER BY OCCUR_TIME DESC,FAULT_LEVEL'
exec(@sqlstring)
GO
(@Num varchar(10))
AS
declare @sqlstring varchar(5000)
set @sqlstring='Select top '+@NUM+' * From TBL_Fault_Alarm where (DISPLAYED <> 1 and TREATED <>1) ORDER BY OCCUR_TIME DESC,FAULT_LEVEL'
exec(@sqlstring)
GO
