------------------------------------------------------------------------------------
-----大量数据的分页
------------------------------------------------------------------------------------
--查询
if exists (select name from sysobjects where name='ResultRows' and type='p')
drop procedure ResultRows
go
CREATE PROCEDURE ResultRows
(
@SQLString nVARCHAR(4000),
@PageCount int,
@ColumnID VARCHAR(255),
@ColumnSort VARCHAR(255)
)
AS
DECLARE @Str nVARCHAR(4000)
SET @Str='SELECT TOP 20 * FROM ('+@SQLString+') T WHERE T.'+@ColumnID+' NOT IN
(SELECT TOP '+CAST((20*(@PageCount-1)) AS VARCHAR(20))+' '+@ColumnID+' FROM ('+@SQLString+') T9 ORDER BY '+@ColumnSort+' desc) ORDER BY '+@ColumnSort+' desc'
--PRINT @Str
EXEC sp_ExecuteSql @Str
GO
在其他存储过程中调用
--单据列表
if exists (select name from sysobjects where name='SaleBillList' and type='p')
drop procedure SaleBillList
go
create procedure SaleBillList
@SaleBargainClient varchar(255),
@SaleFinishDepartment varchar(255),
@SaleFinishPort varchar(255),
@SaleFinishShipName varchar(255),
@PageCount varchar(20)
with encryption
as
declare @SqlString varchar(4000)
set @SqlString='select * from SaleBill,SaleFinish,SalePerform,SaleBargain where SaleBillFinishID=SaleFinishID and SaleFinishPerformID=SalePerformID and SalePerformBargainID=SaleBargainID'
if(@SaleBargainClient<>'')set @SqlString=@SqlString+' and SaleBargainClient like '+'''%'+@SaleBargainClient+'%'''
if(@SaleFinishDepartment<>'')set @SqlString=@SqlString+' and SaleFinishDepartment='+''''+@SaleFinishDepartment+''''
if(@SaleFinishPort<>'')set @SqlString=@SqlString+' and SaleFinishPort like '+'''%'+@SaleFinishPort+'%'''
if(@SaleFinishShipName<>'')set @SqlString=@SqlString+' and SaleFinishShipName like '+'''%'+@SaleFinishShipName+'%'''
exec ResultRows @SqlString,@PageCount,'SaleBillID','SaleBillID'
go
-----大量数据的分页
------------------------------------------------------------------------------------
--查询
if exists (select name from sysobjects where name='ResultRows' and type='p')
drop procedure ResultRows
go
CREATE PROCEDURE ResultRows
(
@SQLString nVARCHAR(4000),
@PageCount int,
@ColumnID VARCHAR(255),
@ColumnSort VARCHAR(255)
)
AS
DECLARE @Str nVARCHAR(4000)
SET @Str='SELECT TOP 20 * FROM ('+@SQLString+') T WHERE T.'+@ColumnID+' NOT IN
(SELECT TOP '+CAST((20*(@PageCount-1)) AS VARCHAR(20))+' '+@ColumnID+' FROM ('+@SQLString+') T9 ORDER BY '+@ColumnSort+' desc) ORDER BY '+@ColumnSort+' desc'
--PRINT @Str
EXEC sp_ExecuteSql @Str
GO
在其他存储过程中调用
--单据列表
if exists (select name from sysobjects where name='SaleBillList' and type='p')
drop procedure SaleBillList
go
create procedure SaleBillList
@SaleBargainClient varchar(255),
@SaleFinishDepartment varchar(255),
@SaleFinishPort varchar(255),
@SaleFinishShipName varchar(255),
@PageCount varchar(20)
with encryption
as
declare @SqlString varchar(4000)
set @SqlString='select * from SaleBill,SaleFinish,SalePerform,SaleBargain where SaleBillFinishID=SaleFinishID and SaleFinishPerformID=SalePerformID and SalePerformBargainID=SaleBargainID'
if(@SaleBargainClient<>'')set @SqlString=@SqlString+' and SaleBargainClient like '+'''%'+@SaleBargainClient+'%'''
if(@SaleFinishDepartment<>'')set @SqlString=@SqlString+' and SaleFinishDepartment='+''''+@SaleFinishDepartment+''''
if(@SaleFinishPort<>'')set @SqlString=@SqlString+' and SaleFinishPort like '+'''%'+@SaleFinishPort+'%'''
if(@SaleFinishShipName<>'')set @SqlString=@SqlString+' and SaleFinishShipName like '+'''%'+@SaleFinishShipName+'%'''
exec ResultRows @SqlString,@PageCount,'SaleBillID','SaleBillID'
go
其次,如果你真的知道,那你知道她说的什么内容吗?就是和你在一起的苦 包含什么,反思一下是不是自己的不足,先从自身找原因;
如果,自己没什么问题,仅仅是因为生活暂时的拮据,那就找个合适的机会,两人开玩笑式的谈谈心,进一步了解一下对方;人多少都有几个异性知己的。如果觉得感情上没有问题,不是那种单向付出爱情的,那就放宽心。最后,good luck.