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

ÁùÕзÀÖ¹SQL×¢Èëʽ¹¥»÷

SQL×¢ÈëÊÇĿǰ±È½Ï³£¼ûµÄÕë¶ÔÊý¾Ý¿âµÄÒ»ÖÖ¹¥»÷·½Ê½¡£ÔÚÕâÖÖ¹¥»÷·½Ê½ÖУ¬¹¥»÷Õ߻ὫһЩ¶ñÒâ´úÂë²åÈëµ½×Ö·û´®ÖС£È»ºó»áͨ¹ý¸÷ÖÖÊֶν«¸Ã×Ö·û´®´«µÝµ½SQLServerÊý¾Ý¿âµÄʵÀýÖнøÐзÖÎöºÍÖ´ÐС£Ö»ÒªÕâ¸ö¶ñÒâ´úÂë·ûºÏSQLÓï¾äµÄ¹æÔò£¬ÔòÔÚ´úÂë±àÒëÓëÖ´ÐеÄʱºò£¬¾Í²»»á±»ÏµÍ³Ëù·¢ÏÖ¡£Óɴ˿ɼûSQL×¢Èëʽ¹¥»÷µÄΣº¦ÊǺܴóµÄ£¬ÄÇô×÷ΪÊý¾Ý¿â¹ÜÀíÔ±¸ÃÈçºÎÀ´·ÀÖÎÄØ£¿ÏÂÃæÕâЩ½¨Òé»òÐí¶ÔÊý¾Ý¿â¹ÜÀíÔ±·ÀÖÎSQL×¢Èëʽ¹¥»÷ÓÐÒ»¶¨µÄ°ïÖú¡£
¡¡¡¡1£®ÆÕͨÓû§Óëϵͳ¹ÜÀíÔ±Óû§µÄȨÏÞÒªÓÐÑϸñµÄÇø·Ö
¡¡¡¡Èç¹ûÒ»¸öÆÕͨÓû§ÔÚʹÓòéѯÓï¾äÖÐǶÈëÁíÒ»¸öDrop TableÓï¾ä£¬ÄÇôÊÇ·ñÔÊÐíÖ´ÐÐÄØ£¿ÓÉÓÚDropÓï¾ä¹ØÏµµ½Êý¾Ý¿âµÄ»ù±¾¶ÔÏ󣬹ÊÒª²Ù×÷Õâ¸öÓï¾äÓû§±ØÐëÓÐÏà¹ØµÄȨÏÞ¡£ÔÚȨÏÞÉè¼ÆÖУ¬¶ÔÓÚÖÕ¶ËÓû§£¬¼´Ó¦ÓÃÈí¼þµÄʹÓÃÕߣ¬Ã»ÓбØÒª¸øËûÃÇÊý¾Ý¿â¶ÔÏóµÄ½¨Á¢¡¢É¾³ýµÈȨÏÞ¡£ÄÇô¼´Ê¹ÔÚËûÃÇʹÓÃSQLÓï¾äÖдøÓÐǶÈëʽµÄ¶ñÒâ´úÂ룬ÓÉÓÚÆäÓû§È¨ÏÞµÄÏÞÖÆ£¬ÕâЩ´úÂëÒ²½«ÎÞ·¨±»Ö´ÐС£¹ÊÓ¦ÓóÌÐòÔÚÉè¼ÆµÄʱºò£¬×îºÃ°Ñϵͳ¹ÜÀíÔ±µÄÓû§ÓëÆÕͨÓû§Çø·Ö¿ªÀ´¡£Èç´Ë¿ÉÒÔ×î´óÏ޶ȵļõÉÙ×¢Èëʽ¹¥»÷¶ÔÊý¾Ý¿â´øÀ´µÄΣº¦¡£
¡¡¡¡2£®Ç¿ÆÈʹÓòÎÊý»¯Óï¾ä
¡¡¡¡Èç¹ûÔÚ±àдSQLÓï¾äµÄʱºò£¬Óû§ÊäÈëµÄ±äÁ¿²»ÊÇÖ±½ÓǶÈëµ½SQLÓï¾ä¡£¶øÊÇͨ¹ý²ÎÊýÀ´´«µÝÕâ¸ö±äÁ¿µÄ»°£¬ÄÇô¾Í¿ÉÒÔÓÐЧµÄ·ÀÖÎSQL×¢Èëʽ¹¥»÷¡£Ò²¾ÍÊÇ˵£¬Óû§µÄÊäÈë¾ø¶Ô²»Äܹ»Ö±½Ó±»Ç¶Èëµ½SQLÓï¾äÖС£Óë´ËÏà·´£¬Óû§µÄÊäÈëµÄÄÚÈݱØÐë½øÐйýÂË£¬»òÕßʹÓòÎÊý»¯µÄÓï¾äÀ´´«µÝÓû§ÊäÈëµÄ±äÁ¿¡£²ÎÊý»¯µÄÓï¾äʹÓòÎÊý¶ø²»Êǽ«Óû§ÊäÈë±äÁ¿Ç¶Èëµ½SQLÓï¾äÖС£²ÉÓÃÕâÖÖ´ëÊ©£¬¿ÉÒԶžø´ó²¿·ÖµÄSQL×¢Èëʽ¹¥»÷¡£²»¹ý¿ÉϧµÄÊÇ£¬ÏÖÔÚÖ§³Ö²ÎÊý»¯Óï¾äµÄÊý¾Ý¿âÒýÇæ²¢²»¶à¡£²»¹ýÊý¾Ý¿â¹¤³ÌʦÔÚ¿ª·¢²úÆ·µÄʱºòÒª¾¡Á¿²ÉÓòÎÊý»¯Óï¾ä¡£
¡¡¡¡3£®¼ÓÇ¿¶ÔÓû§ÊäÈëµÄÑéÖ¤
¡¡¡¡×ÜÌåÀ´Ëµ£¬·ÀÖÎSQL×¢Èëʽ¹¥»÷¿ÉÒÔ²ÉÓÃÁ½ÖÖ·½·¨£¬Ò»ÊǼÓÇ¿¶ÔÓû§ÊäÈëÄÚÈݵļì²éÓëÑéÖ¤£»¶þÊÇÇ¿ÆÈʹÓòÎÊý»¯Óï¾äÀ´´«µÝÓû§ÊäÈëµÄÄÚÈÝ¡£ÔÚSQLServerÊý¾Ý¿âÖУ¬ÓбȽ϶àµÄÓû§ÊäÈëÄÚÈÝÑéÖ¤¹¤¾ß£¬¿ÉÒÔ°ïÖú¹ÜÀíÔ±À´¶Ô¸¶SQL×¢Èëʽ¹¥»÷¡£²âÊÔ×Ö·û´®±äÁ¿µÄÄÚÈÝ£¬Ö»½ÓÊÜËùÐèµÄÖµ¡£¾Ü¾ø°üº¬¶þ½øÖÆÊý¾Ý¡¢×ªÒåÐòÁкÍ×¢ÊÍ×Ö·ûµÄÊäÈëÄÚÈÝ¡£ÕâÓÐÖúÓÚ·ÀÖ¹½Å±¾×¢È룬·ÀֹijЩ»º³åÇøÒç³ö¹¥»÷¡£²âÊÔÓû§ÊäÈëÄÚÈݵĴóСºÍÊý¾ÝÀàÐÍ£¬Ç¿ÖÆÖ´ÐÐÊʵ±µÄÏÞÖÆÓëת»»¡£Õâ¼´ÓÐÖúÓÚ·ÀÖ¹ÓÐÒâÔì³ÉµÄ»º³åÇøÒç³ö£¬¶ÔÓÚ·ÀÖÎ×¢Èëʽ¹¥»÷ÓбȽÏÃ÷ÏÔµÄЧ¹û¡£
¡¡¡¡Èç¿ÉÒÔʹÓô洢¹ý³ÌÀ´ÑéÖ¤Óû§µÄÊäÈë¡£ÀûÓô洢¹ý³Ì¿ÉÒÔʵÏÖ¶ÔÓû§ÊäÈë


Ïà¹ØÎĵµ£º

SQLÊý¾ÝÖÐÔËÐÐcmdÃüÁî

ÔÚsql²éѯ·ÖÎöÆ÷ÀïÃæÊDz»ÄÜÖ±½ÓÔËÐÐcmdÃüÁîµÄ
µ«ÊÇSQL¸ø³öÁËÒ»¸ö½Ó¿Ú
--´ò¿ª¸ß¼¶ÉèÖÃ
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
--´ò¿ªxp_cmdshellÀ©Õ¹´æ´¢¹ý³Ì
EXEC sp_configure 'xp_cmdshell', 1
RECONFIGURE
Ê×ÏÈ ´ò¿ªÒ»Ð©ÅäÖÃ
È»ºóÖ´ÐÐÄãÒªÔËÐÐcmdÃüÁî
exec master..xp_cmdshell 'net star ......

oracle sql ÇóÖÖ²Ëʱ¼ä

-- create by zh
-- n ÊÇ×÷ÎïµÄʱ¼ä,x ÊÇÏ£ÍûÔÚ¼¸µã³ÉÊì,·µ»Ø²¥ÖÖµÄʱ¼ä
with t as
(
select 64 n,9 x from dual union all
select 64 n,13 x from dual union all
select 64 n,17 x from dual union all
select 64 n,20 x from dual
)
select '³ÉÊìʱ¼ä:'     || lpad(to_char(n),4,' ' ......

SQL learning

Five basic search conditions are summarized here:
1) Comparison test
2) Range test
3) Set membership test
4) Pattern matching test (Like)
     The pattern matching test checks to see whether the data value in a column matches a specified pattern
   % mathes any se ......

²ÎÊý»¯SQLÓï¾äSqlParameter


±ÜÃâSQL×¢ÈëµÄ·½·¨ÓÐÁ½ÖÖ£ºÒ»ÊÇËùÓеÄSQLÓï¾ä¶¼´æ·ÅÔÚ´æ´¢¹ý³ÌÖУ¬ÕâÑù²»µ«¿ÉÒÔ±ÜÃâSQL×¢È룬»¹ÄÜÌá¸ßһЩÐÔÄÜ£¬²¢ÇÒ´æ´¢¹ý³Ì¿ÉÒÔÓÉרÃŵÄÊý¾Ý¿â¹ÜÀíÔ±(DBA)±àдºÍ¼¯ÖйÜÀí£¨ÕâÖÖ×ö·¨ÎÒÔÚһЩ¹«Ë¾¼û¹ý£©£¬²»¹ýÕâÖÖ×ö·¨ÓÐʱºòÕë¶ÔÏàͬµÄ¼¸¸ö±íÓв»Í¬Ìõ¼þµÄ²éѯ£¬SQLÓï¾ä¿ÉÄܲ»Í¬£¬ÕâÑù¾Í»á±àд´óÁ¿µÄ´æ´¢¹ý³Ì£¬ËùÒÔÓÐÈËÌá³ ......

SQL Lite

SQL Lite
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
It is a open source product and can be downloaded from http://www.sqlite.org/ . SQL Lite is best suited in Smart Client architecture, where we can locally store all ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ