CREATE PROCEDURE [dbo].[UP_common_pager]
()
AS
BEGIN
DECLARE @strSQL nvarchar(2000)--动态构造出来的SQL语句
DECLARE @strSQLCount nvarchar(2000)--为计算总数量的动态SQL语句
select @strSQL='select * from AAA'
Exec(@strSQL) select @strSQLCount='select count(*) from BBB'
EXEC(@strSQLCount)
END
()
AS
BEGIN
DECLARE @strSQL nvarchar(2000)--动态构造出来的SQL语句
DECLARE @strSQLCount nvarchar(2000)--为计算总数量的动态SQL语句
select @strSQL='select * from AAA'
Exec(@strSQL) select @strSQLCount='select count(*) from BBB'
EXEC(@strSQLCount)
END
SqlDataReader dr = ...;while(dr.Read())
...;dr.NextResult(); // 下个结果集while(dr.Read())
...;