Article View: cn.bbs.comp.database
Article #8371order by ������ [SQL Server 2k]
From: nukq
Date: Fri, 28 Nov 2003 07:52
Date: Fri, 28 Nov 2003 07:52
23 lines
1600 bytes
1600 bytes
�и��� t1 ,��һ�б�� BH ,�������Ϊ varchar ��Բ�ѯ�����BH�������� select * from t1 order by BH ���������� BH ... 1 ... 10 ... 100 ... 101 ... ... 199 ... 2 ... 20 ... ...... �ܲ��ܰ���BH����ֵ��С���а��� 1 2 3.... BH�ֶε����Ͳ��ܸ���ˡ� ���� ��Щ��¼��BH�ֶ��� 'abc' 'add' '*a'���ַ������ַ� ������ select * from t1 order by convert(int,BH) Ҫ���? ����ˣ���
Technical Details
Message-ID:
<bq6ush$deo$1@news.yaako.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.cn99.com!news.yaako.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,7c6618378dabdd38,start X-Google-Attributes: gid101948,public X-Google-ArrivalTime: 2003-11-27 23:53:20 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.cn99.com!news.yaako.com!not-for-mail From: "nukq" <simenking@sohu.com> Newsgroups: cn.bbs.comp.database Subject: order by ������ [SQL Server 2k] Date: Fri, 28 Nov 2003 15:52:52 +0800 Organization: Bentium Ltd. (CN99) Lines: 25 Message-ID: <bq6ush$deo$1@news.yaako.com> Reply-To: "nukq" <simenking@sohu.com> NNTP-Posting-Host: 218.72.11.71 X-Trace: news.yaako.com 1070005970 13784 218.72.11.71 (28 Nov 2003 07:52:50 GMT) X-Complaints-To: usenet@news.yaako.com NNTP-Posting-Date: Fri, 28 Nov 2003 07:52:50 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165