|
两个sql server 2000的通用分页存储过程(8) BEGIN
RETURN
END
DECLARE @new_where1 VARCHAR(1000)
DECLARE @new_where2 VARCHAR(1000)
DECLARE @new_where3 VARCHAR(1000)
DECLARE @new_where4 VARCHAR(1000)
DECLARE @new_order1 VARCHAR(1000)
DECLARE @new_order2 VARCHAR(1000)
DECLARE @Fields VARCHAR(1000)
DECLARE @Sql VARCHAR(8000)
DECLARE @SqlCount NVARCHAR(4000)
SET @Fields = @PrimaryKey + ','
SET @new_where2 = ''
SET @new_where4 = ''
IF ISNULL(@where,'') = ''
BEGIN
SET @new_where1 = ' '
SET @new_where3 = ' WHERE '
END
ELSE
BEGIN
SET @new_where1 = ' WHERE ' + @where + ' '
SET @new_where3 = ' WHERE 1=1 '
+ REPLACE(' AND ' + @where,' AND ',' AND A.')+ ' AND '
END
WHILE CHARINDEX(',',@Fields)>0
BEGIN
SET @new_where2 = @new_where2
+ 'A.' + LTRIM(LEFT(@Fields,CHARINDEX(',',@Fields)-1))
|
