有可能是你的测试数据的问题啊。看看测试数据吧。是不是结果集正好和##TABLE的行数相等。
解决方案 »
- 求助sql语句,没分了,唉……
- sql server 左连接
- 关于服务器上的表如何做一个储存程序自动修改价格
- 如何用一条 SQL语句 或者 自定义函数/存储过程 实现这个过滤查询? *****100分*****
- 帮我写个SQL代码,得出相映结果!有两张表,结构如下,谢谢!!!
- 请教一个SQL
- 200分求2个表统计合并,逻辑有点复杂
- SQL2005附加数据库发生错误
- 十万火急,请DB2高手帮我一个忙(参与就给分)
- 有关MSSQL2000 jdbc的prepareStatement问题,请进,众多论坛无人回帖,急急急!!!
- Primary key 和Foreign key的问题.
- 求存储过程(不知道能不能写出来!请个位瞅瞅)
(@nStartRow int,
@nEndRow int,
@strSql varchar(300),
@nCount int output
)
AS
set nocount on
create table #t_table
(
[rownum][int] IDENTITY(1,1) Primary Key NOT NULL,
[UserID] [int] NOT NULL ,
[UserType] [int] NOT NULL ,
[Nickname] [varchar] (50) NOT NULL ,
[Sex] [int] NOT NULL ,
[Province] [varchar] (20) NOT NULL ,
[Addr] [varchar] (100) NOT NULL ,
[Postalcode] [varchar] (10) NOT NULL ,
[Birthday] [datetime] NOT NULL ,
[certificateType] [varchar] (50) NOT NULL ,
[CertificateCode] [varchar] (60) NOT NULL ,
[Mail] [varchar] (50) NOT NULL ,
[UserWork] [varchar] (100) NOT NULL ,
[Income] [varchar] (50) NOT NULL ,
[Name] [varchar] (50) NOT NULL ,
[Description] [varchar] (300) NULL ,
[Tele] [varchar] (100) NOT NULL ,
[Password] [varchar] (50) NOT NULL ,
[Portrait] [varchar] (300) NULL ,
[Body] [varchar] (100) NULL ,
[Height] [int] NULL ,
[MarryState] [varchar] (100) NOT NULL ,
[Education] [varchar] (100) NOT NULL ,
[Rate] [varchar] (100) NOT NULL ,
[Purpose] [varchar] (100) NOT NULL ,
[Interesting] [varchar] (300) NULL ,
[Character] [varchar] (300) NULL ,
[Fashion] [varchar] (300) NULL ,
[MobileCode] [varchar] (50) NOT NULL ,
[InputTime] [datetime] NULL ,
[HeadImage] [varchar] (100) NULL ,
[Hot] [int] NULL
)set RowCount @nEndRowexec ('insert #t_table
(
[UserID],
[UserType],
[Nickname],
[Sex],
[Province],
[Addr],
[Postalcode],
[Birthday],
[certificateType],
[CertificateCode],
[Mail] ,
[UserWork],
[Income] ,
[Name] ,
[Description],
[Tele] ,
[Password] ,
[Portrait] ,
[Body] ,
[Height] ,
[MarryState],
[Education],
[Rate],
[Purpose],
[Interesting],
[Character],
[Fashion],
[MobileCode],
[InputTime],
[HeadImage],
[Hot]
)' +@strSql )select @nCount=count(*) from #t_table
set nocount off
SELECT * FROM #t_table WHERE rownum >= @nStartRow and rownum<=@nEndRow ORDER BY rownumGO
你返回的是多少?