sqlÓï¾äÓÅ»¯
SQLÓï¾äµÄÓÅ»¯¾ÍÊǽ«ÐÔÄܽϵ͵ÄSQLÓï¾äת»»´ï³ÉͬÑùÄ¿µÄÐÔÄÜÓÅÒìµÄSQLÓï¾ä
ÏÂÃæÎÒÃÇÒ»ÆðÀ´¿´¿´Ò»Ð©¿ÉÒÔÓÅ»¯SQLµÄ·½·¨£¬Ï£Íû´ó¼Ò¶àÌá³öÒâ¼ûÎÒÃǹ²Í¬Ñ§Ï°»òÕßÊÇ´ó¼ÒÓÐʲôºÃµÄÓÅ»¯·½·¨¿ÉÒÔÌá³öÀ´¹²Ïíһϡ£
µÚÒ»ÖÖÓÅ»¯£¨Ê¹ÓÃÖ¸¶¨ÁдúÌæ”*”£©
ʹÓÓ*”¿ÉÒÔ½µµÍ±àдSQLÓï¾äµÄ¸´ÔӶȣ¬µ«ÊÇÈ´½µµÍÁËSQLÓï¾äÖ´ÐеÄЧÂÊ¡£
ͨ¹ýSQLÓï¾äµÄÖ´Ðйý³ÌÎÒÃÇÀ´Á˽âSQLÓï¾äµÄÖ´ÐÐЧÂÊ¡£µ±Ò»ÌõSQLÓï¾ä´Ó¿Í»§¶Ë·¢Ë͵½·þÎñÆ÷¡£ORACLEÐèÒªÖ´ÐÐÒÔϲ½Ö裺
1. ÔÚ¹²Ïí³ØÖÐËÑË÷SQLÓï¾äÊÇ·ñ´æÔÚ¡£
2. ÑéÖ¤SQLÓï¾äµÄÓï·¨ÊÇ·ñÕýÈ·¡£
3. Ö´ÐÐÊý¾Ý×ÖµäÀ´ÑéÖ¤±íºÍÁеĶ¨Òå¡£
4. »ñÈ¡¶ÔÏóµÄ·ÖÎöËø£¬ÒÔ±ãÔÚÓï¾äµÄ·ÖÎö¹ý³ÌÖжÔÏóµÄ¶¨Òå²»»á±»¸Ä±ä¡£
5. ¼ì²éÓû§ÊÇ·ñ¾ßÓÐÏàÓ¦µÄ²Ù×÷ȨÏÞ¡£
6. È·¶¨Óï¾äµÄ×î¼ÑÖ´Ðмƻ®¡£
7. ½«Óï¾äºÍÖ´Ðз½°¸±£´æµ½¹²ÏíµÄSQLÇø
ͨ¹ýÉÏÃæµÄµÚ3ÌõÎÒÃÇÒѾ¿´³öÀ´ÁË£¬Èç¹ûÎÒÃÇÓÃÁË“*”Ìæ´úÁеĻ°¾Í»áÖ´ÐÐÎÒÃǵĵÚÈý²½£¬Ïà·´Èç¹ûÎÒÃÇÃ÷È·µÄÖ¸³öÁËÁÐORACLE¾Í²»»áÈ¥Ö´ÐеÚÈý¸ö²½Öè¡£
ÏÂÃæ¿ÉÒÔͨ¹ý²âÊÔÀ´¿´¿´£º
Select * from cust;
select cust_id from cust;
ͨ¹ýÉÏÃæÁ½ÌõÓï¾äµÄ¶Ô±ÈÎÒÃÇ¿ÉÒÔÇå³þµÄ¿´³öÁ½ÌõÓï¾äµÄÖ´ÐÐʱ¼äµÄ²î±ð£¬Èç¹ûÊý¾Ý½Ï¶à¸üΪÃ÷ÏÔ¡£
µÚ¶þ£¨Ê¹ÓÃWHERE×Ó¾äÀ´Ìæ´úHAVING£©
ʹÓÃHAVING×Ó¾ä¹ýÂË·Ö×飬Ҳ¾ÍÊÇÔÚ·Ö×éÖ®ºó¹ýÂË£¬ÒòΪÐзÖ×éÐèÒªÒ»¶Îʱ¼ä£¬ËùÒÔÓ¦¸Ã¾¡Á¿Ê¹ÓÃWHERE×Ó¾ä¹ýÂËÐУ¬¼õÉÙ·Ö×éµÄÐÐÊý£¬Ò²¾Í¼õÉÙÁË·Ö×éµÄʱ¼ä£¬´Ó¶øÌá¸ß²éѯЧÂÊ¡£
µÚÈý£¨Ê¹ÓÓ>=”Ìæ´ú“>”|ʹÓÓ<=”Ìæ´ú“<”£©
ÀýÈç“ijÁÐ<=8888”ºÍ“ijÁÐ<8889”¼ìË÷½á¹ûÊÇÒ»ÑùµÄ£¬µ«ÊÇЧÂʲ¢²»ÊÇÒ»ÑùµÄ¡£
ʹÓÓ>=”Ìæ´ú“>”|ʹÓÓ<=”Ìæ´ú“<”
ÉÏÃæÁ½¸öÔËËãµÄÇø±ðÔÚÓÚ£¬Èç¹ûʹÓÓijÁÐ<8889”ÔòORACLE»á¶¨Î»µ½8889£¬È»ºóÔÙÈ¥ÕÒ±È8889СµÄÊý¾Ý£¬Èç¹ûʹÓÓijÁÐ<=8888”£¬ÔòORACLEÖ±½Ó¶¨Î»µ½µÈÓÚ8888µÄÊý¡£ËäÈ»ÕâÖÖÓÅ»¯ÏԵòî±ð²»´ó£¬µ«ÊÇÔÚ²éѯÊý¾ÝÁ¿Ìرð´óµÄʱºò£¬ÓÈÆäÔ
Ïà¹ØÎĵµ£º
Ê×ÏÈ˵Ã÷Ò»µã£ºVC³ÌÐòÖÐÓÃADOÁ¬½ÓSQL Server 2005 ºÍÁ¬½Ó SQL Server 2000µÄÓï¾äºÍÁ¬½Ó×Ö·û´®ÊÇÍêÈ«Ò»ÑùµÄ£¬ÏÂÃæµÄ´úÂëÊÊÓÃÓÚÁ½¸öÊý¾Ý¿âµÄÁ¬½Ó¡£
ÁíÒ»µã˵Ã÷£ºÈç¹ûÄãÒÔÇ°°²×°¹ýSQL Server 2000£¬ºóÔÚûÓÐжÔصÄÇé¿öÏÂÓÖ°²×°ÁË2005£¬ÄÇôÄã֮ǰÔÚ2000ÖÐÉèÖõÄÓû§ÃûºÍÃÜÂëÔÚ2005Öлᱣ³Ö£¬¼´Ê¹Äã°²×°2005ʱδÉèÖÃÈκÎÓû§Ãû ......
[MySQLÓÅ»¯] -- ÈçºÎ²éÕÒSQLЧÂʵØϵÄÔÒò
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:chusong
²éѯµ½Ð§ÂÊµÍµÄ SQL Óï¾ä ºó£¬¿ÉÒÔͨ¹ý EXPLAIN »òÕß DESC ÃüÁî»ñÈ¡ MySQL ÈçºÎÖ´ÐÐ SELECT Óï¾äµÄÐÅÏ¢£¬°üÀ¨ÔÚ SELECT Óï¾äÖ´Ðйý³ÌÖбíÈçºÎÁ¬½ÓºÍÁ¬½ÓµÄ˳Ðò£¬±ÈÈçÎÒÃÇÏë¼ÆËã 2006 ÄêËùÓй«Ë¾µÄÏúÊ۶ÐèÒª¹ØÁª sales ......
תÖÁhttp://mbtk.blog.sohu.com/150003773.html £¬²¢²¹³äһЩÏà¹Ø֪ʶ¡£
DBCC ErrorLog £ºÈç¹ûºÜÉÙÖØÆðmssqlserver·þÎñ£¬ÄÇô·þÎñÆ÷µÄÈÕÖ¾»áÔö³¤µÃºÜ¿ì£¬¶øÇÒ´ò¿ªºÍ²é¿´ÈÕÖ¾µÄËÙ¶ÈÒ²»áºÜÂý¡£Ê¹ÓÃÕâ¸öÃüÁ¿ÉÒԽضϵ±Ç°µÄ·þÎñÆ÷ÈÕÖ¾£¬Ö÷ÒªÊÇÉú³ÉÒ»¸öеÄÈÕÖ¾¡£¿ÉÒÔ¿¼ÂÇÉèÖÃÒ»¸öµ÷¶ÈÈÎÎñ£¬Ã¿ÖÜÖ´ÐÐÕâ¸öÃüÁî×Ô¶¯½Ø¶Ï·þÎ ......
--select name from sysobjects where type='U' order by name
SELECT
(case when a.colorder=1 then d.name else '' end) ±íÃû,
-- a.colorder ×Ö¶ÎÐòºÅ,
a.name ×Ö¶ÎÃû,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end) ±êʶ,
(case when (SELECT count(* ......
-- ²é¿´µ±Ç°dbµÄµÇ½
select * from sys.sql_logins
-- ÉóºËµÇ½Êý¾Ý¿âµÄÓû§
sql server managerment studioÖУ¬ÓÒ¼üµã¿ª·þÎñÆ÷µÄÊôÐÔ£¬ÔÚ°²È«ÐÔҳǩÖУ¬ Ñ¡ÖÐÉóºË“³É¹¦ºÍʧ°ÜµÄµÇ½”£¬ËùÓеǽ¶¼»áÔÚ..MSSQL\Log\ERRORLOGÖмǼһÌõ¼Ç¼¡£
Èç¹û¹´Ñ¡“ÆôÓÃC2ÉóºË¸ú×Ù”£¬½«»áÔÚ..MSSQL\Log\Ŀ¼ ......