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

Article View: cn.comp.database

Article #39

#39

From: С��(��)
Date: Sun, 19 Mar 2006 14:46

24 lines
2187 bytes

�����ˣ���ΪʲôҪ�ȷ��ַ��ﰡ��
��Sun, 19 Mar 2006 22:35:26 +0800ʱ,"element"�� ��Re:
��select�����top������ʹ�ñ����� ���з���Ĵ���:
--

>create proc pageview
>@pagenum int=1,
>@pagesize int=10
>as
>declare @pagesum int
>set @pagesum = @pagenum * @pagesize
>
>declare @sql varchar(8000)
>set @sql='select top '+cast(@pagesize as varchar)+' 
>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 '+cast(@pagesum as varchar)+' 
>gbook.[id] from gbook inner join [user] on gbook.u_id =[user].[id]
>ORDER BY gbook.[id] desc))
>ORDER BY gbook.[id] desc'
>exec(@sql)
>go
>
>

Technical Details

Message-ID: <441e6eb5.10831084@cnusenet.3322.org>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newsfeed.media.kyoto-u.ac.jp!news.cn99.com!news.yaako.com!cnusenet.3322.org!not-for-mail

References:

<441de15c.10549329@cnusenet.3322.org> <dvjes0$v2c$1@news.yaako.com> <441d4541.219355@cnusenet.3322.org> <#Ms1Kk1SGHA.1868@TK2MSFTNGP09.phx.gbl> <441d65de.8568400@cnusenet.3322.org> <ujQxeJ2SGHA.5728@tk2msftngp13.phx.gbl>

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!news2.google.com!newsfeed.media.kyoto-u.ac.jp!news.cn99.com!news.yaako.com!cnusenet.3322.org!not-for-mail
From: "С����(��)" <root@guohai.org.discuss>
Newsgroups: cn.comp.database,cn.fan,microsoft.public.cn.sqlserver
Subject: Re: ��select�����top������ʹ�ñ�����
Date: Sun, 19 Mar 2006 22:46:29 +0800
Organization: news://cnusenet.3322.org
Lines: 24
Message-ID: <441e6eb5.10831084@cnusenet.3322.org>
References: <441de15c.10549329@cnusenet.3322.org> <dvjes0$v2c$1@news.yaako.com> <441d4541.219355@cnusenet.3322.org> <#Ms1Kk1SGHA.1868@TK2MSFTNGP09.phx.gbl> <441d65de.8568400@cnusenet.3322.org> <ujQxeJ2SGHA.5728@tk2msftngp13.phx.gbl>
NNTP-Posting-Host: 60.22.215.121
Mime-Version: 1.0
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: 8bit
X-Trace: news.yaako.com 1142779581 15212 60.22.215.121 (19 Mar 2006 14:46:21 GMT)
X-Complaints-To: usenet@news.yaako.com
NNTP-Posting-Date: Sun, 19 Mar 2006 14:46:21 +0000 (UTC)
X-Newsreader: Forte Agent 1.8/32.548
X-Original-NNTP-Posting-Host: 61.51.234.205
X-Original-Trace: 19 Mar 2006 22:46:18 +0800, 61.51.234.205

Reply to Parent Message

Article View: cn.comp.database

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

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