Re: �ʾ�SQL��,лл

Article View: cn.bbs.comp.database

Article #566

Back to cn.bbs.comp.database Previous Next

#566

From: Dem��ɫ�н��
Date: Fri, 06 Feb 2009 14:09

16 lines
1507 bytes

��, cast as float, cast as decimal(xx,x)����cast as double������
�� �� pax (ԡ���ˡ�ϲ���Ϻ�������) �Ĵ������ᵽ: ��
:     ���õ���ʲô��ݿ⣿
:     ����mysql����ͨ���
:     �����MSSQL
:     ��A*1.00/B����A/B
:     ����CAST(A as float)/B
: �� �� Fireflyever (���е�ө��) �Ĵ������ᵽ: ��
: : �ؼ�������A,B������,���Ա���A=1,B=2��A=3,B=4,���ֱ��A/B�Ļ���Ϊ0,�����ΪС��
: : ,���Բ���ֱ����select * from Info order by A/B,�����������


--
http://bbs.sjtu.edu.cn/file/comic/122390669464913.jpg

[m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 58.35.149.158][m

Technical Details

Message-ID: <4eLNT1$bWk@bbs.sjtu.edu.cn>

Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news.isoc.lu!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,fd48b50538cdf067
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news.isoc.lu!news.shec6.edu.cn!SJTU
From: ZAKU.bbs@bbs.sjtu.edu.cn (Dem����ɫ�н�����)
Newsgroups: cn.bbs.comp.database
Subject: Re: �ʾ�SQL���,лл
Date: 06 Feb 2009 14:09:31 GMT
Organization: ��ˮ˼Դ
Message-ID: <4eLNT1$bWk@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1233929329.A

Article View: cn.bbs.comp.database

Re: �ʾ�SQL���,лл

Re: �ʾ�SQL��,лл