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

mssql ¶à±í²éѯµÄÎÊÌâ

ÇëÎÊ£ºÔÚ¶à±í²éѯÖУ¬²éѯ²»Í¬±íÖеĶà¸ö×ֶΣ¬ÆäÖÐÓÐЩ×ֶΰüÀ¨º¯Êý£¬¶àл¸÷λ´óÏÀÖ¸µãÃÔ½ò°¡£¡£¡£¡
±í1
¹¤ºÅ    ÐÕÃû
1      Ëν­
2      ¬¿¡Òå

±í2
¹¤ºÅ    µÃ·Ö    ÆÚÊý
1      50      1
1      60      2
1      64      3

²éѯ½á¹û

ÐÕÃû    µÃ·Ö£¨ÈýÆÚµÄavg£©
Ëν­    58

SQL code:
select ÐÕÃû,µÃ·Ö=avg(µÃ·Ö) from ±í1 A,±í2 B where A.¹¤ºÅ=B.¹¤ºÅ
group by ÐÕÃû


SQL code:
select ÐÕÃû,avg(µÃ·Ö) as µÃ·Ö
from ±í1 inner join ±í2 on ±í1.¹¤ºÅ=±í2.¹¤ºÅ
group by ÐÕÃû



SQL code:
select a.¹¤ºÅ,a.ÐÕÃû,µÃ·Ö=avg(b.µÃ·Ö)
from ±íÒ» a inner join ±í¶þ b on a.¹¤ºÅ=b.¹¤ºÅ
group by a.¹¤ºÅ


SQL code:
1> select * from ±í1;
2> go
¹¤ºÅ |ÐÕÃû
-----------|----------
1|Ëν­
2|¬¿¡Òå

(2 rows


Ïà¹ØÎÊ´ð£º

MSSQL$SQLEXPRESS ·þÎñÆô¶¯ÎÊÌâ

 


MSSQL$SQLEXPRESS  ÎÞ·¨Æô¶¯..  ÖªµÀÈçºÎ´¦ÀíµÄÇë°ï°ïæ  лл
¿´¿´´íÎóÈÕÖ¾

Ìáʾʲô´íÎó?

http://blog.csdn.net/fredrickhu/archive/2009/09/20/4573408.aspx
......

MSSQL±¸·Ý»Ö¸´ºóʹÓÃsaÕÊ»§²»ÄÜ·ÃÎÊ,¸ßÊÖ°ï½â?

mssqlÔÚÁíÍâһ̨µçÄÔÉϻָ´±¸·Ýºó,²»ÄÜÁ¬½Ó,ʹÓÃsaÕÊ»§Ò²²»ÄÜÁ¬½Ó,ÒÔǰҲÓöµ½ÀàËÆÎÊÌâÒ»Ö±µÃ²»µ½½â¾ö

Çë¸ßÊÖ°ïæ½â´ð?

µ«ÊÇÑ¡Ôñ·ÃÎÊÊý¾Ý¿âµÄʱºò,Ìáʾ"21002Óû§""ÒѾ­´æÔÚ"´íÎó?
......

»ñµÃmssqlÊý¾Ý¼¯µÄÎÊÌâ

ÓÉÓÚ×î½üҪдһ¸ö·ÖÒ³µÄ³ÌÐò£¬ÔÚÍøÉÏÕÒÁ˸ö´æ´¢¹ý³Ì£»
  create  procedure add_pp_SqlPager
  @sqlstr nvarchar(4000),                --²éѯ×Ö· ......

Ò»¸öMSSQLµÄÁ¬½ÓÎÊÌâ

°ì¹«ÊÒÀïÓÐ6̨µçÄÔ£¬ÆäÖÐһ̨װÓÐMSSQL 2005 ×÷Ϊ·þÎñÆ÷£¬ÁíÍâÎą̊µçÄÔ¸÷ÓÐÒ»¸öÓû§Ãû£¬¶¼ÉèÖóɿÉÒÔ·ÃÎʵÄÁË¡£µ«Ö»ÓÐÁ½Ì¨¿ÉÒÔÁ¬ÉÏÊý¾Ý¿â£¬ÆäËûµÄ±¨´í£º[DBNETLIB][ConnectionOpen (Connect()).]SQL Server ²»´æÔÚ»ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ