用了微软的那个游标查询后出的问题!!
CREATE PROCEDURE sp_mypager(@sqlstr nvarchar(4000),@Pagecount int, @pagesize int )
-- @slqstr :查询字符串
-- @pagecount 第N 页
--@ pggesize 每页行数
as
set nocount on
declare @P1 int,--P1是游标的id
@rowcount int
exec sp_cursoropen @P1 output,@sqlstr,@scrollopt=1,@ccopt=1,@rowcount=@rowcount output
select @rowcount as 总行数,ceiling(1.0*@rowcount/@pagesize) as 页数,@pagecount as 当前页
set @pagecount=(@pagecount-1)*@pagesize+1
exec sp_cursorfetch @P1,16,@pagecount,@pagesize
exec sp_cursorclose @P1
GO
----------------------------------
exec sp_mypager "select * from Sales_DomainHost,ClientList where ClientList.ClientId=Sales_DomainHost.ClientId AND Sales_DomainHost.ProviderProductId=71 ",1,20
错误提示是
以 'select * from Sales_DomainHost,ClientList where ClientList.ClientId=Sales_DomainHost.ClientId AND Sales_DomainHost.ProviderProdu ' 开头的 标识符 太长。最大长度为 128。
[解决办法]
--try
exec sp_mypager 'select * from Sales_DomainHost,ClientList where ClientList.ClientId=Sales_DomainHost.ClientId AND Sales_DomainHost.ProviderProductId=71 ',1,20
