存储过程,在线等

[jarryjie]

ALTER PROCEDURE dbo.SetIntegration
@InfoID INT = NULL OUTPUT,
@line INT = NULL
AS
SELECT InfoDetail.*
FROM InfoDetail
RETURN
请问各位如何把参数LINE 传入啊,例
SELECT @line InfoDetail.*
FROM InfoDetail
RETURN
我这样传有错!!

[jarryjie]

不是,是select top @line infoDetail.*
from .....
开始写错达,不好意思,这样会出错了

[yown]

declare @line varchar(2)
declare @s nvarchar(200)


set @line='5'

set @s='select top '+@line+' * from sysobjects'

exec sp_executeSql @s,
N'@line varchar(2) ',@line

--动态

[heyixiang]

晕倒

最好进行判断

if @line is null
begin
处理
end
else
begin
select top @line infoDetail.* from .....
end

[Liroyal]

if @line is null
begin
处理
end
else
begin
exec ('select top ' + @line + ' infoDetail.* from .....')
end

[chenyuandxm]

ALTER PROCEDURE dbo.SetIntegration
@InfoID INT = NULL OUTPUT,
@line INT = NULL
AS
SELECT @line InfoDetail.*
FROM InfoDetail
RETURN
go


--下面调用
exec dbo.SetIntegration @line=‘指定的值’

[jarryjie]

各位,我怎么搞都有错啊
还有@line 是我调用过程的时候传入的参数是INT型的
好象select top @line * from .....
说@line 这个附近有语法错误
如果我不做IF的话是这样的
ALTER PROCEDURE dbo.SetIntegration
@InfoID INT = NULL OUTPUT,
@line INT = NULL
AS
SELECT TOP @S InfoDetail.*
FROM InfoDetail
RETURN
请问我怎么处理@line,这个地方啊

[jarryjie]

不是@S是@line

[Liroyal]

是不是提某一行(@line)的记录?

[Frewin]

SELECT @line As line, InfoDetail.*
FROM InfoDetail

[Frewin]

SELECT @line As [l_line], InfoDetail.*
FROM InfoDetail

[Liroyal]

你不写出来了吗, 有问题?
SELECT @line As line, InfoDetail.*
FROM InfoDetail

[l_xiaofeng]

SELECT @line InfoDetail.*
FROM InfoDetail

本身語法就有錯誤 SELECT 1 InfoDetail.* FROM InfoDetail 這樣能出結果嗎？