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
Ïà¹ØÎĵµ£º
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. ......
1. /*+ALL_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='CCBZZP';
2. /*+FIRST_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÏìӦʱ ......
&nbs ......
ÔÌù£ºhttp://topic.csdn.net/u/20100412/11/a4ea520e-7dd0-44d2-98bb-9f62f0ed6160.html?21233
--------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date : 2010-04-14 06:02:36
-- Version:Microsoft SQL Server 2008 (RTM) - 1 ......
¸½:Oracle SQL Developer — À©Õ¹½»Á÷ÖÐÐÄ
http://www.oracle.com/technology/global/cn/products/database/sql_developer/files/extensions.htm
֮ǰ×÷Ϊһ¸öOracle Employee£¬È´×ÜÊÇÔÚʹÓÃPL/SQL Developer£¨¶øÇÒÊÇÆÆ½â°æ£©£¬ÕâʵÔÚÓÐЩ˵²»¹ýÈ¥£¬µ«ÊÇÈçºÎÕÒµ½Ò»¸öºÏÐijÃÊÖµÄÄܹ»Ô ......