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

½¨Á¢Microsoft SQL Server 2005Êý¾Ý²Ö¿â

   Õ⼸ÌìÓÃÁËÒ»ÏÂMicrosoft SQL Server 200µÄ·ÖÎö·þÎñ£¬Ìù³öÀ´¸ø´ó¼Ò·ÖÏíһϡ£
Çë¶à¶àÖ¸Õý¡£Ð»Ð»¡£
Ò»¡¢ÐèÇó£º
½¨Á¢Ò»¸öͼÊé¶©µ¥Í³¼ÆÏµÍ³
1¡¢Í³¼Æ¸÷¸öͼÊé¹Ý¶©µ¥ÊýÁ¿¡£
2¡¢Í³¼Æ¸÷¸öͼÊé¹Ý¶©µ¥µÄ¸÷¸ö״̬µÄÊýÁ¿Õ¼¸ÃͼÊé¹ÝµÄ¶©µ¥ÊýÁ¿µÄ°Ù·Ö±È¡£
3¡¢Í¬Ê±Í³¼ÆÔ­Ê¼ÊýÁ¿ºÍ´¢ÔËÊýÁ¿
¶þ¡¢Êý¾Ý±í
Ö÷ÒªµÄ×Ö¶Î
¶©µ¥ID
µ¥Î»ºÅ£¨Í¼Êé¹Ý±àºÅ£©
µ¥Î»£¨Í¼Êé¹ÝÃû³Æ£©
ԭʼÊýÁ¿
´¢ÔËÊýÁ¿
×îÐÂ״̬£¨¸Ã¶©µ¥µ±Ç°×´Ì¬£©
Èý¡¢ÊµÏÖ£º
1¡¢´ò¿ªVisual Studio 2005 н¨ÏîÄ¿£¬Ñ¡ÔñAnalysis ServicesÏîÄ¿£¬
Ñ¡ÔñÊý¾ÝÔ´Îļþ¼Ð£¬Ð½¨Êý¾ÝÔ´£º
н¨Êý¾ÝÔ´Ïòµ¼Æô¶¯£º
 
µã»÷ÉÏͼн¨³öÏÖÁ¬½ÓÅäÖöԻ°¿ò
ÅäÖ÷½·¨ºÍÁ´½ÓÊý¾Ý¿âµÄÅäÖ÷½·¨Ïàͬ¡£
ÅäÖÃÁ¬½ÓÊý¾ÝÔ´µÄÕʺţ¬ÒÔºó¾ÍÊÇһ·ÏÂÒ»²½£º£©
 
Ñ¡ÔñÊý¾ÝÔ´ÊÓͼÎļþ¼Ð£¬Ð½¨Ò»¸öÊý¾ÝÔ´ÊÓͼ
Ñ¡Ôñº¬ÓÐͳ¼ÆÊý¾ÝµÄ±í£¬ÒÔºó¾ÍÊÇһ·ÏÂÒ»²½£º£©
Ñ¡Ôñ¶àάÊý¾Ý¼¯Îļþ¼Ð£¬Ð½¨¶àάÊý¾Ý¼¯Ò²¾ÍÊÇÒ»¸öCube
ÉèÖÃÊÂʵ±íºÍά¶È±í
Ñ¡Ôñ¶ÈÁ¿Öµ£¬Ò²¾ÍÊÇÈç¹ûÊÇSQL¾ÍÊÇÐèÒªcount,sumµÈҪͳ¼ÆµÄÊý¾Ý
È¡ÏûËùÓÐÑ¡ÏȻºóÑ¡Ôñά¶ÈÒ²¾ÍÊÇSQLÀïÃæGROUP byµÄ×ֶΣ¨ÕâÀïÎÒÑ¡ÔñÁË“×îÐÂ״̬”ºÍ“µ¥Î»”£©
Ñ¡ÔñÈçÉÏ£¬Õâ¸ö²»ÊÇ×îÖÕ½á¹û£¬ºóÃæ»¹ÒªÊÖ¹¤±à¼­¡££¬ÒÔºó¾ÍÊÇһ·ÏÂÒ»²½£º£©
ͨ¹ýä¯ÀÀ´ò¿ª±à¼­Î¬¶È¡£
½¨Á¢Ò»¸ö²ã´Î½á¹¹£¬µ¥Î»ÔÚÉÏ£¬×´Ì¬ÔÚÏ¡£
°Ñ“ͼÊé·ÖÏú ¶©µ¥ ¼ÆÊý”ÖØÃûÃûΪ“¶©µ¥ÊýÁ¿”
Ð޸ĺóÈçÉÏͼ
Çл»µ½ä¯ÀÀÆ÷£¬ÍϷŵ¥Î»µ½ÐÐλÖá£
ÔÙÍÏ·Å×îÐÂ״̬µ½ÐУ¬×îÖÕЧ¹ûÈçÏ¡£
ÍÏ·ÅÏÔʾµÄÊý¾Ý£¬Ò²¾ÍÊÇÃ÷ϸ
ÍÏ·ÅÍê±ÏЧ¹û
ÉèÖÃÏÔʾΪ°Ù·Ö±È
×îÖÕЧ¹û
´ò¿ªMicrosoft SQL Server 2005 µÄSQL Server Management StudioÁ¬½Óµ½·ÖÎö·þÎñ
 Ð½¨²éѯ£¬²éѯ½á¹ûÈçͼ
²éѯÓï¾äÈçÏ£º
with
set [AllCount] as '[ͼÊé·ÖÏú ¶©µ¥].[²ã´Î½á¹¹].[µ¥Î»].[°²»Õ´óѧ     ͼÊé¹Ý].Children'
Member [ͼÊé·ÖÏú ¶©µ¥].[²ã´Î½á¹¹].[µ¥Î»].[°²»Õ´óѧ     ͼÊé¹Ý].[ºÏ¼Æ] as 'aggregate([AllCount])'
Member [ËùÕ¼¶©µ¥Êý°Ù·Ö±È] as '[¶©µ¥ÊýÁ¿]/([¶©µ¥ÊýÁ¿],[ͼÊé·ÖÏú ¶©µ¥].[²ã´Î½á¹¹].[µ¥Î»].[°²»Õ´óѧ     ͼÊé¹Ý].[ºÏ¼Æ])',format_string='#.00%'
select {[Measures].[¶©µ¥ÊýÁ¿],[Measures].[´¢ÔËÊýÁ¿],[Measures].[ԭʼÊýÁ¿],[ËùÕ¼¶©µ¥Êý°Ù·Ö±È]} on


Ïà¹ØÎĵµ£º

SQLÓï¾ä

1. ˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ£¬Ô´±íÃû£ºa£¬Ð±íÃû£ºb)
SQL: select * into b from a where 1<>1;
        2. ˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý£¬Ô´±íÃû£ºa£¬Ä¿±ê±íÃû£ºb)
SQL: insert into b(a, b, c) select d, e, f from b;
        3. ˵Ã÷£º ......

SQL SERVER

sql server·Ö²¼Ê½ÊÂÎñ½â¾ö·½°¸
ÊÊÓû·¾³
²Ù×÷ϵͳ£ºwindows 2003
Êý¾Ý¿â£ºsql server 2000/sql server 2005
ʹÓÃÁ´½Ó·þÎñÆ÷½øÐÐÔ¶³ÌÊý¾Ý¿â·ÃÎʵÄÇé¿ö
Ò»¡¢  ÎÊÌâÏÖÏó
ÔÚÖ´Ðзֲ¼Ê½ÊÂÎñʱ£¬ÔÚsql server 2005ÏÂÊÕµ½ÈçÏ´íÎó£º
ÏûÏ¢ 7391£¬¼¶±ð 16£¬×´Ì¬ 2£¬¹ý³Ì xxxxx£¬µÚ 16 ÐÐ
ÎÞ·¨Ö´ÐиòÙ×÷£¬ÒòΪÁ´½Ó·þÎñ ......

ÓÃË÷ÒýÌá¸ßSQL ServerÐÔÄÜ

 ÔÚ΢ÈíµÄSQL ServerϵͳÖÐͨ¹ýÓÐЧµÄʹÓÃË÷Òý¿ÉÒÔÌá¸ßÊý¾Ý¿âµÄ²éѯÐÔÄÜ£¬µ«ÊÇÐÔÄܵÄÌá¸ßÈ¡¾öÓÚÊý¾Ý¿âµÄʵÏÖ¡£ÔÚ±¾ÎÄÖн«»á¸æËßÄãÈçºÎʵÏÖË÷Òý²¢ÓÐЧµÄÌá¸ßÊý¾Ý¿âµÄÐÔÄÜ¡£¡¡
¡¡¡¡
¡¡¡¡ÔÚ¹ØÏµÐÍÊý¾Ý¿âÖÐʹÓÃË÷ÒýÄܹ»Ìá¸ßÊý¾Ý¿âÐÔÄÜ£¬ÕâÒ»µãÊǷdz£Ã÷ÏԵġ£ÓõÄË÷ÒýÔ½¶à£¬´ÓÊý¾Ý¿âϵͳÖеõ½Êý¾ÝµÄËٶȾÍÔ½¿ì¡£È»¶ø£¬Ðè ......

Ò»ÌõSQLɾ³ýËùÓбíÖÐÊý¾Ý

         ÓÉÓÚ´¦ÓÚϵͳ¿ª·¢µÄºóÆÚ£¬ÐèÒª¸ø¿Í»§ÑÝʾ¡£·¢ÏÖ´óÁ¿µÄ±í£¬´æÔÚ´óÁ¿µÄ²âÊÔÊý¾Ý¡£ÐèÒªÇå³ý£¬ÓÓdelete from tablename” -->  ÔÎËÀ¡£ºóÀ´·¢ÏÖ¾ÓÈ»ÓÐÕâôǿ´óµÄ¶«¶«¡£ £º£©
 EXECUTE sp_msforeachtable 'delete from ?' ......

SQL SERVERÓï·¨

1.´´½¨±í
(1)ÓÃCreate Table ÃüÁî´´½¨±í
Óï·¨:
Create Table tabl_name
({
}column_name As computed_column_expression
}
}[£¬...n]
)
[On {fiegroup | Default}]
[Textimage_On {fiegroup | Default}]
Àý×Ó:
´ò¿ªcustÊý¾Ý¿â£¬´´½¨Ò»¸ö±í£¬¸Ã±í°üº¬ÁËѧÉúµÄÓйØÐÅÏ¢£¬¼´ÓÐѧºÅ¡¢ÐÕÃû¡¢ÐԱ𡢳öÉúÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ