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 Ò»¸ö±íÂú×ãÌõ¼þµÄÐУ¬ºÍÁíÒ»¸ö±íµÄËùÓÐÐÐ
Ïà¹ØÎĵµ£º
±¸·Ý
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-ÍêÕû Êý¾Ý¿â ±¸·Ý', ......
Ç°¶Îʱ¼ä×öÁËÒ»¸öÐéÄâ×éÖ¯µÄ´´½¨¡£Õâ¸öÐéÄâ×éÖ¯µÄ´´½¨ÊÇ´ÓÏÖÓеÄ×éÖ¯ÖжÁÈ¡Êý¾ÝÈ»ºó½øÐзÖÎö±£´æµ½ÐéÄâ×éÖ¯±íÖС£±£´æÖ®ºóдÈÕÖ¾·½±ãͬ²½µ½ÆäËüϵͳÖС£¹«Ë¾Ê¹ÓõÄÖ÷Òª¼¼ÊõÊÇSSH¡£ÓÉÓÚÊÇÐÂÈËûÓÐʲô¾Ñ飬¼Ó֮ʱ¼ä±È½Ï½ôÆÈ£¬×îºóʹÓÃÒ»°ãµÄÂ߼˼Ïëͨ¹ýµÝ¹éÔÚhibernateÏÂ˳Àû´´½¨ÁË¡£¿ÉÊÇ´ÓÏÖÓеÄ×éÖ¯Ö ......
--²éѯµ±Ç°Á¬½ÓµÄʵÀýÃû
select @@servername--²ì¿´ÈκÎÊý¾Ý¿âÊôÐÔ
sp_helpdb master
--ÉèÖõ¥Óû§Ä£Ê½£¬Í¬Ê±Á¢¼´¶Ï¿ªËùÓÐÓû§
alter database Northwind set single_user with rollback immediate--»Ö¸´Õý³£
alter database Northwind set multi_user
--²ì¿´Êý¾Ý¿âÊôÐÔ
sp_helpdb--²ì¿´Êý¾Ý¿â»Ö¸´Ä£Ê½
selec ......
/*
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 ......