ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼äÄÚµÄÆÚ³õ½ð¶î£¬±¾ÆÚÈë¿â½ð¶î£¬±¾ÆÚ³ö¿â½ð¶î£¬±¾ÆÚ½á´æ¡£
kindname,beginmoney,insummoney,outsummoney,endsummoney
¾ßÌå×îºÃÓеãÊý¾ÝÀ´ËµÃ÷һϣ¬·ñÔò¸ã²»ÇåÄãµÄÆÚ³õÊý¾ÝÈçºÎÉú³É
SELECT a.kindname,¡¡¡¡¡¡¡¡¡¡¡¡
from tab3 a
LEFT OUTER JOIN tab2 b ON a.goodskind=b.goodskind
LEFT OUTER JOIN tab1 c ON b.goodsid=c.goodsid
×Ö¶Î˵Ã÷£¿
¿´ÆðÀ´ºÜ¼òµ¥£¬µ«ÊÇÂ¥Ö÷û°ÑÎÊÌâ˵Çå³þ£¬»Ø´ð²»ÁË£¬Ö»ÄÜupÁË...
û¿´Ã÷°×
End_rbody_63326684//-->
¸Ã»Ø¸´ÓÚ2010-02-07 20:54:26±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
happyandsad
(ÇïÌìÂäÒ¶)
µÈ¡¡¼¶£º
#6Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2010-02-08 10:04:39
˵µÄ²»Ã÷°×
Ä㻹ÊǸøÊý¾ÝÈ»ºó¸æËß˵ҪµÃµ½É¶Êý¾ÝÀ´µÄÖ±½Óµã
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......