sql存储过程问题？

[zengbingling]

CREATE proc [dbo].[product_PageByRowNumber]
(
@tableName nvarchar,
@pageIndex int,
@pageSize int,
@indexColumn nvarchar,
@column nvarchar(100),
@condition nvarchar(100)
)
AS
SELECT top @pageSize *
FROM (
SELECT top (@pageSize*@pageIndex) @column,ROW_NUMBER() OVER (ORDER BY @indexColumn DESC) AS RowNumber
FROM @tableName where @condition) as T
WHERE T.RowNumber>(@pageIndex-1)*@pageSize

这种写法不对吗。
错误：必须声明标量变量 "@pageSize"。

[shiyuyao1987]

字符串拼接吧

[angel6709]

只能拼接字符串，

[zengbingling]

谁能给个修改可以执行的代码

[aluogang]

CREATE proc [dbo].[product_PageByRowNumber]
@tableName nvarchar,
@pageIndex int,
@pageSize int,
@indexColumn nvarchar,
@column nvarchar(100),
@condition nvarchar(100)

AS
Declare @sql nvarchar(max)

set @sql='SELECT top '+ @pageSize +'* from ( SELECT top(' +@pageSize*@pageIndex+')'+@column+',ROW_NUMBER() OVER (ORDER BY'+@indexColumn+'DESC) AS RowNumber'
set @sql=@sql+'FROM'+@tableName+'where'+@condition+') as T WHERE T.RowNumber>('+@pageIndex+'-1)*@pageSize'

exec sp_executesql @sql

[大Y]

好些日子不写存储过程了，有点忘记了，呵呵

[yeyucao123]

支持楼上的写法

[yeyucao123]

[Quote=引用 6 楼 hongleidy5000 的回复:]
好些日子不写存储过程了，有点忘记了，呵呵
[/Quote]
你也过来看看，嘿嘿