Create PROCEDURE sp_page
@CurrentPage int, @PageSize int,@Field_Info varchar(100),@Table_info varchar(20),@Field varchar(10),@intOrder int,@field_id varchar(20),@value_info varchar(20)
AS
DECLARE @MinPage int, @MaxPage int
SET @MinPage = (@CurrentPage - 1) * @PageSize + 1
SET @MaxPage = @MinPage + @PageSize - 1
BEGIN
declare @sql varchar(500)
declare @sqlt varchar(100)
declare @order varchar(4)
if @intorder = 0
set @order = 'asc'
else
set @order = 'desc'
if @Field_id like ''
set @sql = 'select ' + @Field_Info + ' from (select ' + @Field_Info + ' , row_number() over(order by ' + @Field + ' ' + @Order + ') as rownumber from ' + @Table_info + ') as a where rownumber between ' + @minpage + ' and ' + @MaxPage
else
set @sql = 'select ' + @Field_Info + ' from (select ' + @Field_Info + ' , row_number() over(order by ' + @Field + ' ' + @Order + ') as rownumber from ' + @Table_info + ') as a where rownumber between ' + @minpage + ' and ' + @MaxPage + ' and ' + @Field_id + ' = ' + @value_info
exec(@sql)
ENDexec sp_page 1,5,'*','user_info','id',0,'',''
消息 245,级别 16,状态 1,过程 sp_page,第 17 行
在将 varchar 值 'select * from (select * , row_number() over(order by id asc) as rownumber from user_info) as a where rownumber between ' 转换成数据类型 int 时失败。
@CurrentPage int, @PageSize int,@Field_Info varchar(100),@Table_info varchar(20),@Field varchar(10),@intOrder int,@field_id varchar(20),@value_info varchar(20)
AS
DECLARE @MinPage int, @MaxPage int
SET @MinPage = (@CurrentPage - 1) * @PageSize + 1
SET @MaxPage = @MinPage + @PageSize - 1
BEGIN
declare @sql varchar(500)
declare @sqlt varchar(100)
declare @order varchar(4)
if @intorder = 0
set @order = 'asc'
else
set @order = 'desc'
if @Field_id like ''
set @sql = 'select ' + @Field_Info + ' from (select ' + @Field_Info + ' , row_number() over(order by ' + @Field + ' ' + @Order + ') as rownumber from ' + @Table_info + ') as a where rownumber between ' + @minpage + ' and ' + @MaxPage
else
set @sql = 'select ' + @Field_Info + ' from (select ' + @Field_Info + ' , row_number() over(order by ' + @Field + ' ' + @Order + ') as rownumber from ' + @Table_info + ') as a where rownumber between ' + @minpage + ' and ' + @MaxPage + ' and ' + @Field_id + ' = ' + @value_info
exec(@sql)
ENDexec sp_page 1,5,'*','user_info','id',0,'',''
消息 245,级别 16,状态 1,过程 sp_page,第 17 行
在将 varchar 值 'select * from (select * , row_number() over(order by id asc) as rownumber from user_info) as a where rownumber between ' 转换成数据类型 int 时失败。
解决方案 »
- SQL casel when Inster
- sql 多个查询 插入 ★错误★急
- 求如下SQL语句,大侠们快来抢分啊!快...
- 求下列结果的SQL语句
- SQL Link server 查询出错
- 疑难求解!关于表数据的合并
- 可能由并发导致的insert异常的问题
- 有谁装了sql server 2005 express,帮我个忙:
- 我的数据库服务器为SQL SERVER 7.0+SP2/(NT SERVER 4.0+SP6),我现在想在该台服务器上增加一个CPU,请问SQL SERVER 会不会自动识别,会不会造成SQL SERVER的不稳定?
- 有那位大侠在工商部门注册过"工作室"?私人做的项目怎样给客户开发票呢?
- 如何insert记录到自增字段
- 卸载SQL2005Express后安装企业版的问题
就搞定了