ÒªÖªµÀsqlÓï¾ä£¬ÎÒÏëÎÒÃÇÓбØÒªÖªµÀsqlserver²éѯ·ÖÎöÆ÷ÔõôִÐÐÎÒôsqlÓï¾äµÄ£¬ÎÒôºÜ¶àÈ˻ῴִÐмƻ®£¬»òÕßÓÃprofileÀ´¼àÊӺ͵÷ÓŲéѯÓï¾ä»òÕß´æ´¢¹ý³ÌÂýµÄÔÒò£¬µ«ÊÇÈç¹ûÎÒÃÇÖªµÀ²éѯ·ÖÎöÆ÷µÄÖ´ÐÐÂ߼˳Ðò£¬ÏÂÊÖµÄʱºò¾ÍÐØÓгÉÖñ£¬ÄÇôÏÂÊÖÊDz»ÊÇÓаÑÎÕµãÄØ£¿
Ò»£º²éѯµÄÂß¼Ö´ÐÐ˳Ðò
(1) FROM < left_table>
(3) < join_type> JOIN < right_table> (2) ON < join_condition>
(4) WHERE < where_condition>
(5) GRO..
°²È«É¾³ýUÅÌʱ£¬´ó¼Ò³£³£»áÓöµ½Ìáʾ“ÎÞ·¨Í£Ö¹‘ͨÓþí’É豸£¬ÇëÉÔºòÔÙÍ£Ö¹¸ÃÉ豸¡£”
ÕâÖÖÇé¿öÏ¿ÉÒÔÇ¿ÐаÎÏÂUÅÌÂ𣿵±È»²»¿ÉÒÔ£¡ÕâʱºòÈç¹ûÇ¿ÐаγýµÄ»°£¬ºÜÈÝÒ×Ë𻵼ÆËã»úU¿Ú»òÕßÄãµÄUÅÌ¡£Èç¹ûÄãµÄUÅÌÉÏÓÐÖØÒªµÄ×ÊÁÏ£¬ºÜÓпÉÄܾʹ˻ٻµÁË¡£ÄÇôӦ¸ÃÔõô°ìÄØ£¿
ÔÚÕâÀïÎÒд¼¸ÖÖ³£ÓõĽâ¾ö·½·¨£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
µÚÒ»ÖÖ·½·¨£¨ÕâÒ²ÊÇÎÒ½¨Òé´ó¼Ò×î³£Óõķ½·¨£©£º
ÍùÍùÎÒÃÇÔÚ°ÑUÅ̵ÄÎļþ»òÕßÊý¾ÝÈ¡³öÀ´µÄʱºò£¬¶¼ÊÇÓõ珴֯”“Õ³Ìù”·½Ê½£¬¶øÈç¹û¸´ÖƵÄÊÇUÅÌÉϵÄÎļþ£¬Õâ¸öÎļþ..
²»ÂÛÊDZʼDZ¾»¹ÊÇ̨»ú ÓеÄʱºòµçÄÔ²»Ã÷ÔÒò¿ª²»ÁË»ú ¾¹ýÒ»¶Îʱ¼äµÄ×Ü½á ¿´¿´ÏÂÃæµÄÂÛÊö »òÐí¶ÔÄãÓÐËù°ïÖú~~ ¿ª»ú½øÈëBIOS¿ÉÄÜÊÇBIOSµç³Ø¿ìûÓеçÁË£¬Èç¹ûÊÇ£¬¸ü»»BIOSµç³Ø¡£
Èç¹û²»Êǽ«BIOS»Ö¸´µ½³ö³§ÉèÖã¬Ò²¿É½«BIOSµç³Ø·ÅµçÊÔÊÔ¡£
Èç¹û»¹²»ÐУ¬ÐÞ¸´Ò»ÏÂϵͳ¡£
1¡¢¿ª»ú°´F8²»¶¯µ½¸ß¼¶Ñ¡Ïî³öÏÖÔÚËÉÊÖ£¬Ñ¡“×î½üÒ»´ÎµÄÕýÈ·ÅäÖԻسµÐÞ¸´¡£
&..
¶¥¼¶Èí·ÓÉROS 2.9.27 + ROS 3.30 ÆÆ½â°²×°°æ ¸½½Ì³Ì
ͼƬ£º
ͼƬ£º
ͼƬ£º
ͼƬ£º
1¡¢SQL ServerµÇ¼ÈÏ֤ģʽÐÞ¸Ä
³ýÁËÆóÒµ¹ÜÀíÆ÷ÖÐÖ±½ÓÐÞ¸ÄÍ⣬¿ÉÒÔÐÞ¸Ä×¢²á±íʵÏÖ£º
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode
1-½öwindows 2-SQL ServerºÍWindows
2¡¢xp_cmdshell½ø³Ì½¨Á¢¼°É¾³ý
Use Master
Exec sp_dropextendedproc N'xp_cmdshell'
Go
Exec sp_addextendedproc N'xp_cmdshell', N'xplog70.dll'
3¡¢·þÎñÆ÷½ø³ÌÆô¶¯/ÖÐÖ¹
ʾÀý£º
exec xp_cmdshell 'net stop "Ap..
Êý¾Ý²É¼¯Æ÷ÊÇ΢ÈíSQL Server 2008ÖÐÔö¼ÓµÄÒ»¸öÐÂÌØÐÔ£¬ËüµÄ¹¦ÄÜÊÇ´Ó¶ą̀·þÎñÆ÷ÉÏÊÕ¼¯ÐÔÄÜÏà¹ØÊý¾Ý£¬²¢´æ´¢ÔÚÖÐÐÄÊý¾Ý²Ö¿â£¬È»ºóͨ¹ýSQL Server Management Studio(SSMS)Öеı¨±í°ÑÊý¾ÝÕ¹ÏÖ³öÀ´¡£±¾ÖÊÉÏ£¬Êý¾ÝÊÕ¼¯Æ÷ʵÏÖÁ˶ԹؼüÐÔÄÜÊý¾Ý(±ÈÈ磬ÐÔÄܼÆÊýÆ÷£¬´Ó¶¯Ì¬¹ÜÀíÊÓͼDMWÖÐץȡµÄÊý¾Ý¿ìÕպʹÅÅ̿ռäÃ÷ϸ)µÄ×Ô¶¯»¯²É¼¯¡£ËüÖ»Äܹ¤×÷ÔÚSQL Server 2008ÖУ¬ÓëÐí¶àÆäËüÓÐÓõÄDBA¹¦Äܲ»Í¬£¬Êý¾Ý²É¼¯Æ÷²¢²»½öÏÞÓÚÆóÒµ°æ²ÅÖ§³Ö¡£
¡¡¡¡SQL Server 2008Êý¾Ý²É¼¯Æ÷µÄ¹¦ÄÜÓÉÒÔϼ¸¸ö×é¼þ×é³É£º
¡¡¡¡1.MsdbϵͳÊý¾Ý¿âÓÃÀ´´æ´¢ËùνµÄÊý¾Ý²É¼¯×é..