create proc a
@rowtoskip int
as
declare @sql varchar(8000)
set @sql = 'SELECT TOP PageSize Column1,Column2,...FROM MyTable
WHERE KeyColumn NOT IN
(SELECT TOP ' + @RowToSkip + ' KeyColumn FROM MyTable ORDER BY SortOrder)
ORDER BY SortOrder
'
exec (@sql)
@rowtoskip int
as
declare @sql varchar(8000)
set @sql = 'SELECT TOP PageSize Column1,Column2,...FROM MyTable
WHERE KeyColumn NOT IN
(SELECT TOP ' + @RowToSkip + ' KeyColumn FROM MyTable ORDER BY SortOrder)
ORDER BY SortOrder
'
exec (@sql)
一个小小的问题是@RowToSkip前面是int,后面是varchar,要进行转换才行。