°²×°SQL Server 2005ÐÔÄܼàÊÓÆ÷¼ÆÊýÆ÷ÒªÇó (´íÎó)
ÊÖ¶¯ÉèÖüÆÊýÆ÷×¢²á±íÏîµÄÔöÁ¿ :
1.ÔÚ Microsoft Windows 2003 »ò Windows XP ×ÀÃæÉÏ£¬ÒÀ´Îµ¥»÷“¿ªÊ¼”¡¢“ÔËÐД£¬È»ºóÔÚ“´ò¿ª”ÖмüÈë regedit.exe£¬ÔÙµ¥»÷“È·¶¨”¡£ÔÚ Windows 2000 ÖУ¬Ê¹Óà regedt32.exe Æô¶¯×¢²á±í±à¼Æ÷¡£
2.¶¨Î»µ½ÒÔÏÂ×¢²á±íÏ
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]
"Last Counter"=dword:00000ed4 (5276)
"LastHelp"=dword:00000ed5 (5277)
3.ÉÏÒ»²½µÄ“Last Counter”Öµ (5276) ±ØÐëÓëÒÔÏÂ×¢²á±íÏîÖГPerflib\004”µÄ“Counter”ÏîµÄ×î´óֵƥÅ䣬²¢ÇÒÉÏÒ»²½µÄ“Last Help”Öµ (5277) ±ØÐëÓëÒÔÏÂ×¢²á±íÏîÖГPerflib\004”µÄ“Help”ÏîµÄ×î´óֵƥÅä¡£
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009]
×¢Òâ 009Öд洢µÄÊÇÓ¢Îİ汾µÄ¼ÆÊýÆ÷(Èç¹ûÄã°²×°µÄÊÇÓ¢ÎİæMicrosoft SQL Server2005ÔòÐÞ¸ÄPerflib\009)£¬004Öд洢µÄÊÇÖÐÎİ汾µÄ¼ÆÊýÆ÷(Èç¹ûÄã°²×°µÄÊÇÖÐÎİæMicrosoft SQL Server2005ÔòÐÞ¸ÄPerflib\004)¡£“Last Counter”ºÍ“Last Help”ÖµÊÇÓÉ Windows ¶¯Ì¬·ÖÅäµÄ£»ÕâÁ½¸öÖµ»áÒò¼ÆËã»úµÄ²»Í¬¶ø²»Í¬¡£
Ïà¹ØÎĵµ£º
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(CREATE£¬ALTER£¬DROP£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(SELECT£¬DELETE£¬UPDATE£¬INSERT)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢É¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ ......
SELECT CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
SELECT CONVERT(varchar(100), GETDATE(), 1): 05/16/06
SELECT CONVERT(varchar(100), GETDATE(), 2): 06.05.16
SELECT CONVERT(varchar(100), GETDATE(), 3): 16/05/06
SELECT CONVERT(varchar(100), GETDATE(), 4): 16.05.06
SELECT CONVERT(varch ......
SQL×¢Èëʽ¹¥»÷ÊÇÀûÓÃÊÇÖ¸ÀûÓÃÉè¼ÆÉϵÄ©¶´£¬ÔÚÄ¿±ê·þÎñÆ÷ÉÏÔËÐÐSqlÃüÁîÒÔ¼°½øÐÐÆäËû·½Ê½µÄ¹¥»÷¶¯Ì¬Éú³ÉSqlÃüÁîʱûÓжÔÓû§ÊäÈëµÄÊý¾Ý½øÐÐÑéÖ¤ÊÇSql×¢Èë¹¥»÷µÃ³ÑµÄÖ÷ÒªÔÒò¡£
±ÈÈ磺
Èç¹ûÄãµÄ²éѯÓï¾äÊÇselect * from admin where username="&user&" and password="&pwd&""
ÄÇô£¬Èç¹ûÎÒµÄÓû§ÃûÊ ......
ÔÚ½øÐвÙ×÷֮ǰ£¬½¨Ò鱸·ÝºÃ×¢²á±íÒÔ¼°ÖØÒªµÄÊý¾Ý¿âÎļþ¡£
£¨1£© ɾ³ýÒÔÏÂ×¢²á±í×ÓÏ
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ Microsoft SQL Server
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentC ......