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

¹ØÓÚSQLÁªºÏ²éѯµÄÎÊÌâ

SQL code:

select MID,m.HName,md.ToothKind,COUNT(md.ToothKind) as ÊýÁ¿,SUM(md.Price) as ×ܼÛ
from MDetail md
left outer join Mechanic m on m.ID=md.MID
where MID='1'
group by m.HName,md.ToothKind,MID
go

select count(*) from MDetail where MID='1'



ÒÔÉÏÁ½ÌõSQLÓï¾ä£¬ÎªÊ²Ã´µÚÒ»ÌõʹÓÃÁªºÏ²éѯµÃ³öµÄÊýÁ¿½á¹û¸úµÚ¶þÌõÓï¾äµÄ½á¹û²»Ò»ÑùÄØ£¿ÄÇÒªÔõÃ´È¡ÄØ£¿

==============================================================
µÚÒ»Ìõ½á¹û£º
MID    HName  ToothKind  ÊýÁ¿    ×ܼÛ
-----------------------------------------
1      ÖÐÒ½Ôº aaa 96 30912.00
1      ÖÐÒ½Ôº ddd 164 .00
1      ÖÐÒ½Ôº ccc 60 .00
==============================================================
µÚ¶þÌõ½á¹û£º
80
==============================================================


ÓïÒâ¶¼²»Ò»Ñù°É¡£¡£

ÒýÓÃ
ÓïÒâ¶¼²»Ò»Ñù°É¡£¡£

ÎÒ¶¼ÊÇҪȡÊýÁ¿µÄ°¡

ÄÇÎÒÁªºÏ²éѯÄÇÑùд¶Ô²»¶ÔÄØ£¿

µÚÒ»¸öÊǰ´ÕÕ3¸ö·Ö×é  ·Ö±ðÇóÊýÁ¿  µÚ2¸ö×Ö×ÜÊýÁ¿ µ±È»²»Ò»Ñù

count(distinct md.ToothKind) ÊÔÊÔ
ÄãÁª²éµÄ»° Èç¹ûÓÒ±ßÓжàÌõ·ûºÏÌõ¼þµÄ m.ID=md.MIDµÄ»° ½á¹û¼¯ÖоͻáÔö¼ÓÏàÓ¦µÄÐÐ

Ŷ xiaof˵µÄ¶Ô

ÄÇÈç¹ûÎÒҪȡMechanic±íÔÚMDetail±íÖж


Ïà¹ØÎÊ´ð£º

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿

ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
        @SYS_ORGANIZE varchar(10), ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ