RT
ºÃÏñ¿¼MSSQLÖ¤·ÖºÃ¼¸ÖÖŶ?
×ÉѯÏ ÓÐʲôÏà¹Ø×ÊÁÏô£¿
Õâ¸öÕæ²»Çå³þ£¬°ï¶¥°É
µ±È»ÊÇMICROSOFTµÄMCSEÁË
..
°ï¶¥
°ï¶¥Ï°ɡ£¡£
MS SQL ÈÏÖ¤
2000:mcdba
2005:·ÖÈý¸öϵÁÐ ¹ÜÀí ¿ª·¢ ÉÌÒµÖÇÄÜ ¸÷ÓÐÁ½¸ö¼¶±ð mcts mcitp
ÏêϸÇé¿ö£¬ÔÚ΢ÈíÍøÕ¾ÉÏ¿´
SQL Server 2005΢ÈíÈÏÖ¤¼¼Êõר¼ÒϵÁУ¨MCITP£©
1£©¡¢sql2005Êý¾Ý¿âר¼Ò£º¿¼3ÃÅ
µÚÒ»ÃÅ£º070-431--- sql2005ʵʩÓëά»¤
µÚ¶þÃÅ£º070-443--- sql2005Éè¼ÆÊý¾Ý·þÎñÆ÷»ù´¡¼Ü¹¹
µÚÈýÃÅ£º070-444--- sql2005ÓÅ»¯²¢Î¬»¤Êý¾Ý¿â¹ÜÀí½â¾ö·½°¸Êý
Èç¹ûÄúÒÑÓµÓÐMCDBAÈÏÖ¤£¬¿ÉÒÔͨ¹ý070-447Éý¼¶¿¼ÊÔ½«ÄúµÄ¼¼ÄÜÉý¼¶¡£
2£©¡¢sql2005Êý¾Ý¿â¿ª·¢×¨¼Ò£º¿¼3ÃÅ
µÚÒ»ÃÅ£º070-431---sql2005ʵʩÓëά»¤
µÚ¶þÃÅ£º070-441--- sql2005Éè¼ÆÊý¾Ý¿â½â¾ö·½°¸
µÚÈýÃÅ£º070-442--- sql2005Éè¼Æ²¢ÓÅ»¯Êý¾Ý´æÈ¡
3£©¡¢sql2005Êý¾Ý¿âÉÌÒµÖÇÄܽâ¾ö·½°¸¿ª·¢×¨¼Ò£º¿¼3ÃÅ
µÚÒ»ÃÅ£º070-431---sql2005ʵʩÓëά»¤
µÚ¶þÃÅ£º070-445--- sql2005·ÖÎö·þÎñÉè¼ÆÉÌÒµÖÇÄÜ
µÚÈýÃÅ£º070-446--- sql2005Éè¼ÆÉÌÒµÖÇÄÜ»ù´¡¼Ü¹¹
http://www.microsoft.com/china/learning/mcp/mcitp/default.mspx
¸öÈËÊÇÏ뿼 2005 »òÕß2008
²»ÖªµÀÄĸöºÃ¡£¡£×Éѯ
ÒýÓà ¸öÈËÊÇÏ뿼2005 »òÕß2008 ²»ÖªµÀÄĸöºÃ¡£¡£×Éѯ 2008
ÒýÓÃ
Ïà¹ØÎÊ´ð£º
´ÓÍøÉÏ¿´Á˺ܲ»ÉÙÕâ·½ÃæµÄ˵·¨£¬¶ÔÎÒÀ´ËµÓô¦²»ÊǺܴó¡£ÏÖÔÚ½«Ò»¸ösql serverµÄÊý¾Ý¿âÀïµÄÊý¾Ýµ¼Èëµ½mysqlÖУ¬ÀïÃæµÄ×Ö¶ÎÓÐËù¸Ä¶¯µÄ¡£×Ô¼ºÐ´ÁËÒ»¸öµ¼ÈëµÄ²»ÊǺÜÀíÏ룬ÀÏÊǶªÊý¾Ý£¬²»ÖªµÀÊÇʲôÔÒò£¬»¹Íû¸ßÊÖûָµã° ......
ÒÔÏÂÊÇÎÒMSSQLµÄ´¢´æ¹ý³Ì£¬Ï£Íû¸ßÊÖÄܰïÎÒת»»Îª Mysql µÄ´¢´æ¹ý³ÌллÁË£¡ »òÕß´ó¼ÒÓÐû¼û¹ýÕâÀàÐ͵ÄÈí¼þ°¡£¡ set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER proced ......
select * from todaytask where datediff("n",taskonlinetime,getdate()) <15 order by rank asc,addtasktime desc ÕâÀï²éѯ 15·ÖÖÓÔÚÏßµÄÈÎÎñ ͨ¹ýrankºÍaddtasktimeÅÅÐò rankÊýֵΠ......
SQL code: For Ls_desc IN (Select Di_ename ,Di_Pcs,Di_Unitprice from T_BO_DeclareInvoice Di WHERE bs_code = as_bs_code) LOOP IF Ls_desc.Di_ename IS ......
¸÷λ´óÏÀ £¬ÎÒ½ñÌì×öÁ˸öjob£¬sqlÊÇ exec proc_showresult. ¿É¾ÍÊDz»ÄÜÖ´ÐÐ £¬È»ºóÎÒ°ÉÕâ¸ösql»»³É select 1¡£¾ÍûÎÊÌ⣬ÕâÊÇʲôÔÒò°¡ Çë¸ßÊÖÖ¸½Ì ´æ´¢¹ý³ÌÓвÎÊýû?? Ò²ÐíÊÇÖ´ÐÐÁË,Äãû ......