Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

°²×°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×¢Èë¼°·À·¶

ËùνSQL×¢Èëʽ¹¥»÷£¬¾ÍÊǹ¥»÷Õß°ÑSQLÃüÁî²åÈëµ½Web±íµ¥µÄÊäÈëÓò»òÒ³ÃæÇëÇóµÄ²éѯ×Ö·û´®£¬ÆÛÆ­·þÎñÆ÷Ö´ÐжñÒâµÄSQLÃüÁî¡£ÔÚijЩ±íµ¥ÖУ¬Óû§ÊäÈëµÄÄÚÈÝÖ±½ÓÓÃÀ´¹¹Ôì(»òÕßÓ°Ïì)¶¯Ì¬SQLÃüÁ»ò×÷Ϊ´æ´¢¹ý³ÌµÄÊäÈë²ÎÊý£¬ÕâÀà±íµ¥ÌرðÈÝÒ×Êܵ½SQL×¢Èëʽ¹¥»÷¡£³£¼ûµÄSQL×¢Èëʽ¹¥»÷¹ý³ÌÀàÈ磺
¡¡¡¡¢Å ij¸öASP.NET WebÓ¦ÓÃÓÐÒ»¸ö ......

±í½á¹¹ÐÅÏ¢²éѯ sql server 2005


--sql server 2005
-- 1. ±í½á¹¹ÐÅÏ¢²éѯ
-- ========================================================================
-- ±í½á¹¹ÐÅÏ¢²éѯ
-- ×Þ½¨ 2005.08(ÒýÓÃÇë±£Áô´ËÐÅÏ¢)
-- ========================================================================
SELECT
    TableName=CASE WHEN ......

SQLÖÐʹÓÃCONVERTת»»Ê±¼äÊä³ö¸ñʽ

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ÃüÁîʱûÓжÔÓû§ÊäÈëµÄÊý¾Ý½øÐÐÑéÖ¤ÊÇSql×¢Èë¹¥»÷µÃ³ÑµÄÖ÷ÒªÔ­Òò¡£
±ÈÈ磺
Èç¹ûÄãµÄ²éѯÓï¾äÊÇselect * from admin where username="&user&" and password="&pwd&""
 ÄÇô£¬Èç¹ûÎÒµÄÓû§ÃûÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ