SQL Server ÈÏÖ¤(Certification)
΢ÈíµÄÊý¾Ý¿âÈÏÖ¤´Ó°üÀ¨3¸ö·½ÃæµÄ£º
MCTS: Microsoft Certified Technology Specialist
MCITP: Microsoft Certified IT Professional
MCM: Microfot Certified Master.
΢Èí½¨Òé²Î¼Ó×îа汾µÄÊý¾Ý¿âÈÏÖ¤¿¼ÊÔ£¬µ±Ç°°æ±¾ÊÇÖ¸Microsoft SQL Server 2008¡£
SQL Server2008 MCTS°üÀ¨3¸öÈÏÖ¤£º
1> SQL Server 2008 Implementation and Maintenace;
2> SQL Server 2008 Database Development;
3> SQL Server Business Intelligence Development and Maintenance.
SQL Server 2008 MCITP Ò²°üº¬3¸öÈÏÖ¤£º
1> Database Administrator IT Professional;
2> Database Developer IT Professional;
3> Business Intelligence Developer IT Professional.
MCITP±ÈMCTSÒª¿¼²ìµÄ·¶Î§¸ü¹ã£¬ÒªÇó¶ÔSQL Server 2008¼¼ÊõÁ˽âµÄ¸ü¾«Ï¸¡£ËùÒÔMCITPÒª±ÈMCTSÉÔ΢ÄѹýЩ¡£
MCMµ½2009Äê4Ô·ÝÈ«ÇòÖ»ÓÐ2¸öÈËͨ¹ýÁË¡£Õâ¸öÈÏÖ¤ÎÞÂÛÊǶԼ¼ÊõµÄÒªÇ󣬻¹ÊÇ»¨·ÑµÄ½ðÇ®¶¼ÊÇÏà¶Ô½Ï¸ßµÄ£¬ÕâÀï¾Í²»ÔÙÏêϸ½éÉÜÁË£¬ÓÐÐËȤµÄÅóÓÑ¿ÉÒÔ²ÎÕÕ
www.microsoft.com/learning/mcp/master/sql/default.mspx
Ïà¹ØÎĵµ£º
SQL Server 2000 µÄϵͳÊý¾Ý¿â
SQL Server 2000·þÎñÆ÷°²×°ºó»á½¨Á¢4ϵͳÊý¾Ý¿â¡£·Ö±ðÊÇmaster¡¢model¡¢msdb¡¢tempdb¡£
1¡¢masterÊý¾Ý¿â
masterÊý¾Ý¿âÊÇSQL Server 2000ÖÐ×îÖØÒªµÄÊý¾Ý¿â£¬¼Ç¼ÁËSQL Server 2000µÄ·þÎñÆ÷¼¶ÏµÍ³ÐÅÏ¢£¬°üÀ¨ËùÓÐÕË»§ºÍÃÜÂ룬´ÅÅ̿ռ䡢Îļþ·ÖÅäºÍʹÓá¢ÏµÍ³¼¶µÄÅäÖòÎÊý¡ ......
̽ÌÖÈçºÎÔÚÓÐ×Å1000ÍòÌõÊý¾ÝµÄMS SQL SERVERÊý¾Ý¿âÖÐʵÏÖ¿ìËÙµÄÊý¾ÝÌáÈ¡ºÍÊý¾Ý·ÖÒ³¡£ÒÔÏ´úÂë˵Ã÷ÁËÎÒÃÇʵÀýÖÐÊý¾Ý¿âµÄ“ºìÍ·Îļþ”Ò»±íµÄ²¿·ÖÊý¾Ý½á¹¹£º
CREATE TABLE [dbo].[TGongwen] ( --TGongwenÊǺìÍ·Îļþ±íÃû
[Gid] [int]&nb ......
http://weblogs.asp.net/scottgu/archive/2007/09/07/linq-to-sql-part-9-using-a-custom-linq-expression-with-the-lt-asp-linqdatasource-gt-control.aspx
1-9 parts are the most useful knowledge for you so far. ......
³ÌÐòÆô¶¯Sql ServerÆäʵºÜ¼òµ¥
´úÂ룺
System.ServiceProcess.ServiceController myController =
new System.ServiceProcess.ServiceController("MSSQL$ACCP4444"); //·þÎñÃû³Æ ÕÒÁ˰ëÌì²ÅÕÒµ½£¬±¿ËÀÎÒÍêÁË¡£ÔÚ·þÎñÉÏÓÒ¼üÊôÐÔ£¬ÄÜ¿´µ½
if (myController.CanStop)
{ }
else ......