Re: ��select��top��ʹ�ñ��

Article View: cn.comp.database

Article #46

#46

From: ddddd
Date: Wed, 12 Apr 2006 03:34

28 lines
2293 bytes

"С����(��)" <root@guohai.org.discuss> wrote in message
news:441de15c.10549329@cnusenet.3322.org...
> ���봴������һ���洢��̵�˵��
> ������: ��Ϣ 170������ 15��״̬ 1����� pageview���� 8
> �� 8 ��: '@pagesize' �������﷨����
> ������: ��Ϣ 170������ 15��״̬ 1����� pageview���� 12
> �� 12 ��: '@pagesum' �������﷨����
> Ӧ����ô�������
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> create proc pageview
> @pagenum int=1,
> @pagesize int=10
> as
> declare @pagesum int
> set @pagesum = @pagenum * @pagesize
>
> select top @pagesize
> gbook.[id],gbook.title,gbook.neirong,[user].[name],[user].[id]
> from gbook inner join [user]
> on gbook.u_id =[user].[id]
> WHERE (gbook.[id] NOT IN
> (SELECT TOP @pagesum gbook.[id]
> from gbook inner join [user]
> on gbook.u_id =[user].[id]
> ORDER BY gbook.[id] desc))
> ORDER BY gbook.[id] desc
> go

Technical Details

Message-ID: <e1hupv$pk$2@news.cn99.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!wn12feed!worldnet.att.net!4.24.21.153!newsfeed3.dallas1.level3.net!newsfeed2.dallas1.level3.net!news.level3.com!bloom-beacon.mit.edu!news.cn99.com!not-for-mail

References: <441de15c.10549329@cnusenet.3322.org>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1106d1,1421f408f40b2353
X-Google-Thread: 107c7f,1421f408f40b2353
X-Google-Thread: 104772,1421f408f40b2353
X-Google-Attributes: gid1106d1,gid107c7f,gid104772,public
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!wn12feed!worldnet.att.net!4.24.21.153!newsfeed3.dallas1.level3.net!newsfeed2.dallas1.level3.net!news.level3.com!bloom-beacon.mit.edu!news.cn99.com!not-for-mail
From: "ddddd" <anxin19810421@tom.com>
Newsgroups: cn.comp.database,cn.fan,microsoft.public.cn.sqlserver
Subject: Re: ��select�����top������ʹ�ñ�����
Date: Wed, 12 Apr 2006 11:34:17 +0800
Organization: Bentium Ltd. (CN99)
Lines: 30
Message-ID: <e1hupv$pk$2@news.cn99.com>
References: <441de15c.10549329@cnusenet.3322.org>
NNTP-Posting-Host: 222.240.227.38
X-Trace: news.cn99.com 1144815231 820 222.240.227.38 (12 Apr 2006 04:13:51 GMT)
X-Complaints-To: usenet@news.cn99.com
NNTP-Posting-Date: Wed, 12 Apr 2006 04:13:51 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700

Reply to Parent Message

Article View: cn.comp.database

Re: ��select�����top������ʹ�ñ�����

Re: ��select��top��ʹ�ñ��