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

sql(left join,right jion,inner join)Á¬½ÓÏê½â

 ¹ØÓÚsqlÁ¬½Ó
Á¬½ÓÀàÐÍ
ÔÚ¹Øϵ´úÊýÖУ¬Á¬½ÓÔËËãÊÇÓÉÒ»¸öµÑ¿¨¶û»ýÔËËãºÍÒ»¸öÑ¡È¡ÔËËã¹¹³ÉµÄ¡£Ê×ÏÈÓõѿ¨¶û»ýÍê³É¶ÔÁ½¸öÊý¾Ý¼¯ºÏµÄ³ËÔËË㣬Ȼºó¶ÔÉú³ÉµÄ½á¹û
¼¯ºÏ½øÐÐÑ¡È¡ÔËË㣬ȷ±£Ö»°Ñ·Ö±ðÀ´×ÔÁ½¸öÊý¾Ý¼¯ºÏ²¢ÇÒ¾ßÓÐÖصþ²¿·ÖµÄÐкϲ¢ÔÚÒ»Æð¡£Á¬½ÓµÄÈ«²¿ÒâÒåÔÚÓÚÔÚˮƽ·½ÏòÉϺϲ¢Á½¸öÊý¾Ý¼¯ºÏ£¨Í¨³£ÊÇ±í£©£¬²¢²úÉú
Ò»¸öеĽá¹û¼¯ºÏ£¬Æä·½·¨Êǽ«Ò»¸öÊý¾ÝÔ´ÖеÄÐÐÓÚÁíÒ»¸öÊý¾ÝÔ´ÖкÍËüÆ¥ÅäµÄÐÐ×éºÏ³ÉÒ»¸öÐÂÔª×é¡£
SQLÌṩÁ˶àÖÖÀàÐ͵ÄÁ¬½Ó·½Ê½£¬ËüÃÇÖ®¼äµÄÇø±ðÔÚÓÚ£º´ÓÏ໥½»µþµÄ²»Í¬Êý¾Ý¼¯ºÏÖÐÑ¡ÔñÓÃÓÚÁ¬½ÓµÄÐÐʱËù²ÉÓõķ½·¨²»Í¬¡£
Á¬½ÓÀàÐÍ          ¶¨Òå
ÄÚÁ¬½Ó          Ö»Á¬½ÓÆ¥ÅäµÄÐÐ
×óÍâÁ¬½Ó          °üº¬×ó±ß±íµÄÈ«²¿ÐУ¨²»¹ÜÓұߵıíÖÐÊÇ·ñ´æÔÚÓëËüÃÇÆ¥ÅäµÄÐУ©£¬ÒÔ¼°Óұ߱íÖÐÈ«²¿Æ¥ÅäµÄÐÐ
ÓÒÍâÁ¬½Ó          °üº¬Óұ߱íµÄÈ«²¿ÐУ¨²»¹Ü×ó±ßµÄ±íÖÐÊÇ·ñ´æÔÚÓëËüÃÇÆ¥ÅäµÄÐУ©£¬ÒÔ¼°×ó±ß±íÖÐÈ«²¿Æ¥ÅäµÄÐÐ
È«ÍâÁ¬½Ó          °üº¬×ó¡¢ÓÒÁ½¸ö±íµÄÈ«²¿ÐУ¬²»¹ÜÁíÍâÒ»±ßµÄ±íÖÐÊÇ·ñ´æÔÚÓëËüÃÇÆ¥ÅäµÄÐС£
(H)(theta)Á¬½Ó          ʹÓõÈÖµÒÔÍâµÄÌõ¼þÀ´Æ¥Åä×ó¡¢ÓÒÁ½¸ö±íÖеÄÐÐ
½»²æÁ¬½Ó          Éú³ÉµÑ¿¨¶û»ý£­Ëü²»Ê¹ÓÃÈκÎÆ¥Åä»òÕßÑ¡È¡Ìõ¼þ£¬¶øÊÇÖ±½Ó½«Ò»¸öÊý¾ÝÔ´ÖеÄÿ¸öÐÐÓëÁíÒ»¸öÊý¾ÝÔ´µÄÿ¸öÐж¼Ò»Ò»Æ¥Åä
ÔÚINFORMIXÖÐÁ¬½Ó±íµÄ²éѯ
Èç¹ûfrom×Ó¾äÖ¸¶¨Á˶àÓÚÒ»¸ö±íÒýÓã¬Ôò²éѯ»áÁ¬½ÓÀ´×Ô¶à¸ö±íµÄÐС£Á¬½ÓÌõ¼þÖ¸¶¨¸÷ÁÐÖ®¼ä£¨Ã¿¸ö±íÖÁÉÙÒ»ÁУ©½øÐÐÁ¬½ÓµÄ¹Øϵ¡£ÒòΪÕýÔڱȽÏÁ¬½ÓÌõ¼þÖеÄÁУ¬ËùÒÔËüÃDZØÐë¾ßÓÐÒ»ÖµÄÊý¾ÝÀàÐÍ¡£
SELECTÓï¾äµÄfrom×Ó¾ä¿ÉÒÔÖ¸¶¨ÒÔϼ¸ÖÖÀàÐ͵ÄÁ¬½Ó
from×Ó¾ä¹Ø¼ü×Ö          ÏàÓ¦µÄ½á¹û¼¯
CROSS JOIN          µÑ¿¨¶û³Ë»ý£¨ËùÓпÉÄܵÄÐжԣ©
INNER JOIN          ½ö¶ÔÂú×ãÁ¬½ÓÌõ¼þµÄCROSSÖеÄÁÐ
LEFT OUTER JOIN          Ò»¸ö±íÂú×ãÌõ¼þµÄÐУ¬ºÍÁíÒ»¸ö±íµÄËùÓÐÐÐ


Ïà¹ØÎĵµ£º

sql ±¸·ÝºÍɾ³ý

±¸·Ý
DECLARE @strPath NVARCHAR(200)
set @strPath = convert(NVARCHAR,getdate(),120)
set @strPath='hq'+rtrim(left(replace(@strPath,'-',''),8))
set @strPath = 'D:\sqlback\mydb\' + @strPath + '.bak'
BACKUP DATABASE [mydb] TO DISK = @strPath WITH NOFORMAT, NOINIT, NAME = N'mydb-ÍêÕû Êý¾Ý¿â ±¸·Ý', ......

oracleÖÐʵÏֵݹé²éѯµÄSQL£¨connect by prior£©

    Ç°¶Îʱ¼ä×öÁËÒ»¸öÐéÄâ×éÖ¯µÄ´´½¨¡£Õâ¸öÐéÄâ×éÖ¯µÄ´´½¨ÊÇ´ÓÏÖÓеÄ×éÖ¯ÖжÁÈ¡Êý¾ÝÈ»ºó½øÐзÖÎö±£´æµ½ÐéÄâ×éÖ¯±íÖС£±£´æÖ®ºóдÈÕÖ¾·½±ãͬ²½µ½ÆäËüϵͳÖС£¹«Ë¾Ê¹ÓõÄÖ÷Òª¼¼ÊõÊÇSSH¡£ÓÉÓÚÊÇÐÂÈËûÓÐʲô¾­Ñ飬¼Ó֮ʱ¼ä±È½Ï½ôÆÈ£¬×îºóʹÓÃÒ»°ãµÄÂß¼­Ë¼Ïëͨ¹ýµÝ¹éÔÚhibernateÏÂ˳Àû´´½¨ÁË¡£¿ÉÊÇ´ÓÏÖÓеÄ×éÖ¯Ö ......

Microsoft SQL Server ¹ÜÀí £¨³£ÓùÜÀí¼°Î¬»¤ÃüÁ

 --²éѯµ±Ç°Á¬½ÓµÄʵÀýÃû
select @@servername--²ì¿´ÈκÎÊý¾Ý¿âÊôÐÔ
sp_helpdb master
--ÉèÖõ¥Óû§Ä£Ê½£¬Í¬Ê±Á¢¼´¶Ï¿ªËùÓÐÓû§
alter database Northwind set single_user with rollback immediate--»Ö¸´Õý³£
alter database Northwind set multi_user
--²ì¿´Êý¾Ý¿âÊôÐÔ
sp_helpdb--²ì¿´Êý¾Ý¿â»Ö¸´Ä£Ê½
selec ......

MS SQL µÝ¹éº¯Êý


/*
select *,dbo.getDeptTree(id) as DeptTree from sysdept
µÝ¹éº¯Êý
*/
CREATE  function getDeptTree(@NodeId int)
returns varchar(8000)
as
begin
    declare @ret varchar(8000),@ParentId int,@len int
    set @len = 0
  &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ