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

sqlÊÓͼÎÊÌâÇóÖú - .NET¼¼Êõ / C#

ÓÐÁ½¸ö±í£¬Ò»¸öÊÇÉÌÆ·±íalpro
ID int 4 ¶¨ÒåͼÊéidºÅ
lb varchar 20 ¼Ç¼ͼÊéËùÊôÀà±ð
shuliang int 4 ¼Ç¼ͼÊéµÄ¿â´æ
price2 float ¼Ç¼ͼÊéµÄ¼Û¸ñ
Ò»¸öÊÇÏúÊÛ±íxse
proid ¼Ç¼ÏúÊÛͼÊéµÄid
sl ¼Ç¼ÏúÊÛµÄÊýÁ¿
addtime ¼Ç¼ͼÊéÏúÊÛµÄʱ¼ä
Ïë×öÒ»¸öÊÓͼ£¬¾ÍÊǰ´ÉÌÆ·µÄÀà±ð¼ÆËã³öÿ¸öÔÂÿÖÖÀà±ðÉÌÆ·ÏúÊ۵Ľð¶î
¸øµã²âÊÔÊý¾Ý°É£¡~~

select
a.lb
,sum(isnull(a.price2,0)*isnull(b.sl,0)) as price
from
xse b
left join
alpro a
on
a.ID = b.proid
group by
a.lb,convert(varchar(6),b.addtime,112)


ÒýÓÃ
¸øµã²âÊÔÊý¾Ý°É£¡~~

ÉÌÆ·±í
ͼÊéid Àà±ð µ¥¼Û
45 ÎÄÒÕ 1  
34 ¿Æ¼¼ 5
ÏúÊÛ¶î±í
ͼÊéid ÏúÊÛÊýÁ¿ ÏúÊÛʱ¼ä
45 2 2010-4-5 16:17:17
45 3 2010-4-4 16:17:17
45 2 2010-3-5 16:17:17
34 1 2010-4-5 16:17:17

¾ÍÊÇÉÌÆ·±íÀïÃæÓÐЩÉÌÆ·µÄÀà±ð»áÊÇÒ»ÑùµÄ

»¹ÐèÒªÏÔʾÉÌÆ·Ãû³Æ??

²»ÐèÒª

ÒýÓÃ
select
a.lb
,sum(isnull(a.price2,0)*isnull(b.sl,0)) as price
from
xse b
left join
alpro a
on
a.ID = b.proid
group by
a.lb,convert(varchar(6),b.addtime,112)

Ðֵܣ¬ÄãÕâ¸ö²»Ðйþ

µÈµÈ
ÔÚ°ïÄãд


LZ¿´¿´ÊDz»ÊÇÕâ¸ö½á¹û

¹þ¹þ¹þ,Õâ²»ÊÇÒ»ÑùÂð~!?? Ö»²»¹ý ϲ


Ïà¹ØÎÊ´ð£º

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



type Exception report


message

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

exception

org.apache.jas ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

winform±à³ÌÓëASP.NETÓÐÁ¬ÏµÂð - .NET¼¼Êõ / C#

ÆäʵÕâ¸öÎÊÌâ¿ÉÒÔÕÒÀÏʦ»Ø´ð£¬Õâ²»·Å¼ÙÁËÂð£¬ÎÊÎʸ÷λ¸ßÊÖ¡£
¾ø¶ÔÓÐ £¬ASP¡¢netÀïÓкöàµÄÂß¼­Åжϵȶ¼ÐèÒªwinform»ù´¡

C#ÓïÑÔ 
Ado.net C/S½á¹¹
Asp.net B/S½á¹¹

Á©¶¼ÊÇ΢Èí³öµÄ£¬¶¼ÄÜÓÃC#½øÐпª·¢ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ