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

SQL 2008ÖеÄÍÚ¾òÄ£ÐÍ

SQL Server 2008 Áª»ú´ÔÊ飨2009 Äê 7 Ô£©
ÍÚ¾òÄ£ÐÍ£¨Analysis Services - Êý¾ÝÍÚ¾ò£©
±¾½Ú½éÉÜÁËÊý¾ÝÍÚ¾òÄ£Ð͵Ļù±¾Ìåϵ½á¹¹£¬¸ÅÊöÁËÊý¾ÝÍÚ¾òÄ£Ð͵ÄÊôÐÔ£¬²¢ËµÃ÷ÁË´´½¨ºÍ´¦ÀíÍÚ¾òÄ£Ð͵ķ½Ê½¡£
Mining Model Architecture
Defining Mining Models
Mining Model Properties
Mining Model Columns
Processing Mining Models
Viewing and Querying Mining Models
 ÍÚ¾òÄ£ÐÍÌåϵ½á¹¹
Êý¾ÝÍÚ¾òÄ£ÐÍ´ÓÍÚ¾ò½á¹¹ÖлñÈ¡Êý¾Ý£¬È»ºóʹÓÃÊý¾ÝÍÚ¾òËã·¨·ÖÎöÕâЩÊý¾Ý¡£ÍÚ¾ò½á¹¹ºÍÍÚ¾òÄ£ÐÍÊǵ¥¶ÀµÄ¶ÔÏó¡£ÍÚ¾ò½á¹¹´æ´¢¶¨ÒåÊý¾ÝÔ´µÄÐÅÏ¢¡£ÍÚ¾òÄ£Ðʹ洢ͨ¹ýÊý¾ÝµÄͳ¼Æ´¦Àí¶øµÃµ½µÄÐÅÏ¢£¬ÀýÈç·¢ÏÖµÄģʽ£¬¼´·ÖÎö½á¹û¡£
ÔÚ´¦Àí²¢·ÖÎöÍÚ¾ò½á¹¹ËùÌṩµÄÊý¾Ý֮ǰ£¬ÍÚ¾òÄ£ÐÍһֱΪ¿Õ¡£ÔÚ´¦ÀíÍÚ¾òÄ£ÐÍÖ®ºó£¬¸ÃÄ£Ðͽ«°üº¬ÔªÊý¾Ý¡¢½á¹ûºÍÖ¸»Øµ½ÍÚ¾ò½á¹¹µÄ°ó¶¨¡£
ÔªÊý¾ÝÖ¸¶¨Ä£Ð͵ÄÃû³ÆºÍ´æ´¢Ä£Ð͵ķþÎñÆ÷ÒÔ¼°Ä£Ð͵͍Ò壬°üÀ¨Éú³ÉÄ£ÐÍʱËùʹÓõÄÍÚ¾ò½á¹¹ÖеÄÁеÄÁÐ±í¡¢´¦ÀíÄ£ÐÍʱӦÓõĿÉѡɸѡÆ÷µÄ¶¨ÒåÒÔ¼°ÓÃÓÚ·ÖÎöÊý¾ÝµÄËã·¨¡£ÁС¢É¸Ñ¡Æ÷ºÍËã·¨µÄÑ¡Ôñ»á¼«´óµØÓ°Ïì·ÖÎö½á¹û¡£ÀýÈ磬Èç¹ûʹÓÃÏàͬµÄÊý¾Ý´´½¨¾ÛÀà·ÖÎöÄ£Ðͺ;ö²ßÊ÷Ä£ÐÍ£¬Á½¸öÄ£Ð͵ÄÄ£ÐÍÄÚÈÝ¿ÉÄÜ´ó²»Ïàͬ£¬ÒòΪÕâÁ½¸öÄ£ÐÍʹÓò»Í¬µÄËã·¨ºÍɸѡÆ÷¡£ÓйØÏêϸÐÅÏ¢£¬Çë²ÎÔÄÍÚ¾òÄ£ÐÍÄÚÈÝ£¨Analysis Services - Êý¾ÝÍÚ¾ò£©¡£
Ä£ÐÍÖд洢µÄ½á¹ûÒòËã·¨¶øÒ죬µ«¿ÉÒÔ°üÀ¨Ä£Ê½¡¢Ï¡¢¹æÔòºÍ¹«Ê½¡£ÕâЩ½á¹û¿ÉÓÃÓÚ½øÐÐÔ¤²â¡£
Ä£ÐÍÖд洢µÄ°ó¶¨Ö¸»Øµ½ÍÚ¾ò½á¹¹Öлº´æµÄÊý¾Ý¡£Èç¹ûÒÑÔڽṹÖлº´æÊý¾Ý£¬µ«ÔÚ´¦ÀíºóδÇå³ýÕâЩÊý¾Ý£¬ÔòʹÓÃÕâЩ°ó¶¨¿ÉÒÔ´Ó½á¹û×êÈ¡µ½Ö§³ÖÕâЩ½á¹ûµÄÊÂÀý¡£µ«ÊÇ£¬Êµ¼ÊÊý¾Ý´æ´¢Ôڽṹ»º´æÖУ¬¶ø²»ÊÇÄ£ÐÍÖС£
[·µ»ØÒ³Ê×]
 ¶¨ÒåÊý¾ÝÍÚ¾òÄ£ÐÍ
Äú¿ÉÒÔÔÚÏÂÃæµÄ²½Öè´´½¨Ò»¸öÊý¾ÝÍÚ¾òÄ£ÐÍ£º
´´½¨»ù´¡ÍÚ¾ò½á¹¹¡£
Ñ¡ÔñÒ»ÖÖËã·¨¡£
Ö¸¶¨Ä£ÐÍÁкÍÓ÷¨¡£
£¨¿ÉÑ¡£©ÉèÖòÎÊýÒÔ΢µ÷Ëã·¨ËùÖ´ÐеĴ¦Àí¡£
´¦ÀíÄ£ÐÍ¡£
Analysis Services ÌṩÏÂÁпɰïÖúÄú¹ÜÀíÍÚ¾òÄ£Ð͵Ť¾ß£º
Êý¾ÝÍÚ¾òÏòµ¼¿É°ïÖúÄú´´½¨½á¹¹ºÍÏà¹ØÍÚ¾òÄ£ÐÍ¡£ÕâÊÇ×î¼òµ¥µÄʹÓ÷½·¨¡£¸ÃÏòµ¼×Ô¶¯´´½¨ËùÐèµÄÍÚ¾ò½á¹¹£¬²¢°ïÖúÄúÅäÖÃÖØÒªÉèÖá£
DMX CREATE MODEL Óï¾ä¿ÉÓÃÓÚ¶¨ÒåÄ£ÐÍ¡£ËùÐè½á¹¹½«×÷Ϊ¹ý³ÌµÄÒ»²¿·Ö×Ô¶¯´´½¨£»Òò´Ë£¬²»ÄÜÀûÓø÷½·¨ÖØÓÃÏÖÓнṹ¡£Èç¹ûÄúÒÑÈ·ÇÐÖªµÀÒª´´½¨ÄÄÖÖÄ£ÐÍ£¬ÇëʹÓô˷½·¨¡£
DMX ALTER STRUCTURE ADD MODEL Óï¾ä¿ÉÓÃÓÚÏòÏÖÓнṹÖÐÌí¼ÓеÄÍÚ¾òÄ£ÐÍÈç¹ûÒª»ùÓÚÏàͬÊý¾Ý¼¯ÊÔÑ鲻ͬģÐÍ£¬


Ïà¹ØÎĵµ£º

SQLÊÂÎñ´¦ÀíÓï¾ä×ܽá

 
´æ´¢¹ý³ÌÖг£Óõ½µÄSQLÊÂÎñ´¦ÀíÓï¾ä¸ñʽ¿ÉÄÜ»áÓÐÈçϼ¸ÖÖ:
µÚÒ»ÖÖ:
set   xact_abort   on 
begin   tran 
        insert   ... 
        update   ... 
    ......

¹ØÓÚ sql server ÊÓͼ

    Ôø¾­ÓÐÏëͨ¹ý´´½¨sql serverÊÓͼµ÷ÕûÓ¦ÓÃÐÔÄܵÄÏë·¨£¬²»¹ýºóÀ´Ö¤Ã÷Õâ¸öÏë·¨ÊÇÐв»Í¨µÄ¡£
    ×öÁ˸öʵÑ飬ÔÚ¶ÔÔ­À´µÄsqlÓï¾äµ÷ÕûÖ®ºó´´½¨ÁËÁ½¸öÊÓͼ£¬°ÑÔ­À´µÄsqlת»»ÎªÊÓͼÁË£¬Í¨¹ýÊÓͼÀ´¶ÁÈ¡Êý¾Ý¡£×îÖյıȽϽá¹ûÊÇͨ¹ýÊÓͼ±ÈÖ±½ÓʹÓÃsqlÓï¾äÒªÂý£¬Í¨¹ýÊÓͼÀ´Ìá¸ßsqlµÄÐÔÄÜ¿´À´ÊDz»ÐÐ ......

SQLÕù°ÔÈüÊÔÌâ¼°²Î¿¼´ð°¸

1.ijҽԺ²¡·¿¼ÆËã»ú¹ÜÀíÖÐÐèÒªÈçÏÂÐÅÏ¢£º£¨15·Ö£©
¿ÆÊÒ£º¿ÆÃû£¬¿ÆµØÖ·£¬¿Æµç»°
²¡·¿£º²¡·¿ºÅ£¬ËùÊô¿ÆÊÒÃû
Ò½Éú£ºÐÕÃû£¬Ö°³Æ£¬ËùÊô¿ÆÊÒÃû£¬ÄêÁ䣬¹¤×÷Ö¤ºÅ
²¡ÈË£º²¡ÀúºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬Õï¶Ï£¬Ö÷¹ÜÒ½Éú£¬²¡·¿ºÅ£¬ÈëסÈÕÆÚ
ÆäÖУ¬Ò»¸ö¿ÆÊÒÓжà¸ö²¡·¿¡¢¶à¸öÒ½Éú£¬Ò»¸ö²¡·¿Ö»ÄÜÊôÓÚÒ»¸ö¿ÆÊÒ£¬Ò»¸öÒ½ÉúÖ»ÊôÓÚÒ»¸ö¿ÆÊÒ£¬µ«¿É¸º ......

È«¹úËùÓгÇÊÐSQL

 --Ê¡¼¶   Provincial
--³ÇÊР  City
create table Provincial(pid int,Provincial varchar(50),primary key (pid))
insert into Provincial values(1,'±±¾©ÊÐ')
insert into Provincial values(2,'Ìì½òÊÐ')
insert into Provincial values(3,'ÉϺ£ÊÐ')
insert into Provincial values(4,'Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ