Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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²éѯ ÖØ¸´¼Ç¼

1¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select   peopleId  from   people  group  by   peopleId  having  count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö× ......

Microsoft SQL Server ¹ÜÀí £¨³£ÓùÜÀí¼°Î¬»¤ÃüÁ

 --²éѯµ±Ç°Á¬½ÓµÄʵÀýÃû
select @@servername--²ì¿´ÈκÎÊý¾Ý¿âÊôÐÔ
sp_helpdb master
--ÉèÖõ¥Óû§Ä£Ê½£¬Í¬Ê±Á¢¼´¶Ï¿ªËùÓÐÓû§
alter database Northwind set single_user with rollback immediate--»Ö¸´Õý³£
alter database Northwind set multi_user
--²ì¿´Êý¾Ý¿âÊôÐÔ
sp_helpdb--²ì¿´Êý¾Ý¿â»Ö¸´Ä£Ê½
selec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ