Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÇóÖú£ºSQL Server²éѯ - MS-SQL Server / ÒÉÄÑÎÊÌâ

Á½¸ö±í£¬Ò»¸ö»áÔ±±í£¬Ò»¸öÏû·Ñ¼Ç¼±í¡£ÐèÒª²éµÄÊÇ×î½üÏû·ÑµÄ»áÔ±£¬È»ºó»áÔ±±íͨ¹ýÏû·Ñʱ¼äµ¹ÐòÅÅÐò¡£ÇóÖú´ó¼ÒÔõô×ö¡£ÎÒ´òËãÏÈ·Ö×飬ͳ¼Æ¿¨»áÔ±µÄ¸öÊý£¬È»ºóÔÚͨ¹ýÏû·Ñ±íÖеÄÏû·Ñʱ¼äÌõ¼þÅÅÐò£¬µ«ÕâÑùÅÅÐòÍêÈ«²»ÐС£ÇóÖú´ó¼Ò¸ÃÈçºÎ½â¾ö£¬Ð»Ð»£¡
¸ø³ö±íµÄ½á¹¹¡¢²âÊÔÊý¾Ý¡¢¼°½á¹û

×î½üµÄ·¶Î§½üµ½ÄÄÀÓÐûÓÐÃ÷È·µÄ·¶Î§

ÒýÓÃ
×î½üµÄ·¶Î§½üµ½ÄÄÀÓÐûÓÐÃ÷È·µÄ·¶Î§



·¶Î§Ö»Êǵ¹Ðò¶øÒÑ¡£

ÒýÓÃ
¸ø³ö±íµÄ½á¹¹¡¢²âÊÔÊý¾Ý¡¢¼°½á¹û


»áÔ±±í£ºMember 
Ïû·Ñ¼Ç¼±í£ºCashLog 
Ïû·Ñ¼Ç¼ÖÐ×ÔÈ»±£³Ö×ŶàÌõµ¥¸ö»áÔ±ÐÅÏ¢£¬ÐèÒª²éѯ×î½üÏû·ÑÅÅÐòµÄÌõ¼þÏû·Ñʱ¼äTimeÊôÓÚCashLog±í¡£


ÒýÓÃ
Á½¸ö±í£¬Ò»¸ö»áÔ±±í£¬Ò»¸öÏû·Ñ¼Ç¼±í¡£ÐèÒª²éµÄÊÇ×î½üÏû·ÑµÄ»áÔ±£¬È»ºó»áÔ±±íͨ¹ýÏû·Ñʱ¼äµ¹ÐòÅÅÐò¡£ÇóÖú´ó¼ÒÔõô×ö¡£ÎÒ´òËãÏÈ·Ö×飬ͳ¼Æ¿¨»áÔ±µÄ¸öÊý£¬È»ºóÔÚͨ¹ýÏû·Ñ±íÖеÄÏû·Ñʱ¼äÌõ¼þÅÅÐò£¬µ«ÕâÑùÅÅÐòÍêÈ«²»ÐС£ÇóÖú´ó¼Ò¸ÃÈçºÎ½â¾ö£¬Ð»Ð»£¡


SQL code:

SELECT a.»áÔ±Ãû, MAX(b.Ïû·Ñʱ¼ä) Ïû·Ñʱ¼ä
from »áÔ±±í a
JOIN Ïû·Ñ¼Ç¼±í b
ON a.»áÔ±ID = b.»áÔ±ID
GROUP BY a.»áÔ±Ãû
ORDER BY Ïû·Ñʱ¼ä DESC


SQL code:
select a.*,b.*
from »áÔ±±í a
left join Ïû·Ñ¼Ç¼±í b on a.»áÔ±ID=b.


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......

SQLÄܽøÐжþ½øÖƵÄɸѡÂ𣿠- MS-SQL Server / »ù´¡Àà

ÎÒÓÐÒ»¸ö×Ö¶ÎÊÇ varchar(1) ÀàÐÍ£¬¶þ½øÖƱíʾҲ¾ÍÊÇ8λµÄ ¡®0000 0000¡¯
±ÈÈçÕâ¸öʱºòÎÒÐèҪɸѡ³öÕâ¸ö×Ö¶ÎΪËùÓÐµÄ ¡®0000 0100¡¯µÄÐУ¬ÇëÎÊSQLÄÜʵÏÖÕâÑùµÄ¡°Î»¡±µÄɸѡÂð£¿
лл~~~

ÓÐλ²Ù×ݺ¯ÊýÂ𣿲»ÐоÍ× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ