Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¡¢²éÕÒ±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select   peopleId  from   people  group  by   peopleId  having  count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖØ¸´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö× ......

SQL Server ÖÐASµÄÌØÊâÐÔ

 ÍâÁ¬½ÓÈ¡Êý¾ÝÈç¹ûΪ¿Õ£¬²»´æÔÚASʱ¿ÉÄÜÈ¡µ½Êý¾Ý£¬µ«¼ÓÁËAS¾Í»á±¨´í¡£±ÈÈçSelect Top 10 a.*,b.Class AS ClassId
,b.DeviceName from AuxBusInfo a Left Join  DeviceCandidate b On a.InitialDeviceRscId = b.DeviceRscId Order By AuxBusId£¬µ± ......

Sql Server 2005/2008±¸·Ý/ɾ³ý¹ýÆÚ±¸·ÝT

 USE [master]
GO
/****** ¶ÔÏó:  StoredProcedure [dbo].[sp_backupdatabase]    ½Å±¾ÈÕÆÚ: 07/15/2009 16:23:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[sp_backupdatabase]
@bak_path nvarchar(4000)='',       ......

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ºÅ