create proc proc_pageWebUser
@pagesize int,
@pageindex int,
@UserName varchar (20)
as
declare @sql varchar(255)
set @sql='select top '+ str(@pagesize) +'* from WebUser UserName like '%'+@UserName+'%' and id not in (select top' +str((@pageindex-1) * @pagesize) +'id from WebUser)'
exec(@sql)
GO
@pagesize int,
@pageindex int,
@UserName varchar (20)
as
declare @sql varchar(255)
set @sql='select top '+ str(@pagesize) +'* from WebUser UserName like '%'+@UserName+'%' and id not in (select top' +str((@pageindex-1) * @pagesize) +'id from WebUser)'
exec(@sql)
GO
解决方案 »
- 两个表链接的 Like问题
- SQLSERVER 32位 在WIN2003 64位 如何设置内存
- 在sql脚本中,在一个查询中,对同一个字段使用5个like,有没有办法优化一下?
- 大家帮帮忙呀!一个sql语句的问题!
- 用sp_executesql 能不能将返回赋给一个游标?
- 字段删除不了!???
- SQL2000 导入 PowerDesigner 12
- 请问为何我的MASTER数据库多了 INFORMATION_SCHEMA 和 system_function_schema 两个用户?
- 特别困难的问题!!!
- 远程连接问题!盼答复
- 用程序调用存储过程提示成功却没有作用
- 这个SQL的COUNT数字该怎么写啊?
@pagesize int,
@pageindex int,
@UserName varchar (20)
as
declare @sql varchar(255)
set @sql='select top '+ ltrim(@pagesize) +'* from WebUser UserName like '%'+@UserName+'%' and id not in (select top' +ltrim((@pageindex-1) * @pagesize) +'id from WebUser)'
exec(@sql)
GO
@pagesize int,
@pageindex int,
@UserName varchar (20)
as
declare @sql varchar(255)
set @sql='select top '+ str(@pagesize) +'* from WebUser where UserName like and id not in (select top' +str((@pageindex-1) * @pagesize) +'id from WebUser)'
exec(@sql)
GO 这样都对了 like ''%'+@UserName+'%''
@pagesize int,
@pageindex int,
@UserName varchar (20)
as
declare @sql varchar(8000) declare @COUNT INT
SET @COUNT=(@pageindex-1) * @pagesize
set @sql='
select top '+ ltrim(@pagesize) +'*
from WebUser UserName like ''%'+@UserName+'%''
and id not in (select top' +ltrim(@COUNT) +'id from WebUser)'
exec(@sql)
GO
@pagesize int,
@pageindex int,
@UserName varchar (20)
as
declare @sql varchar(8000) declare @COUNT INT
SET @COUNT=(@pageindex-1) * @pagesize
set @sql='
select top '+ ltrim(@pagesize) +'*
from WebUser UserName like ''%'+@UserName+'%''
and id not in (select top' +ltrim(@COUNT) +'id from WebUser)'
exec(@sql)
GO