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-ÍêÕû Êý¾Ý¿â ±¸·Ý', ......
½«b±íÖÐcallerÁеÄÖµ²åÈëa±íÖÐcallÁÐÖС£
create table a
(
fid int,
call varchar(20),
age int
)
create table b
(
fid int,
caller varchar(20),
parentId int
)
select * from a
select * from b
insert into a values(1,null,19)
insert into a values(2,n ......
asc °´ÉýÐòÅÅÁÐ
desc °´½µÐòÅÅÁÐ
ÏÂÁÐÓï¾ä²¿·ÖÊÇMssqlÓï¾ä£¬²»¿ÉÒÔÔÚaccessÖÐʹÓá£
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)
Ê×ÏÈ,¼òÒª½éÉÜ»ù´¡Óï¾ä£º
1¡¢ËµÃ÷£º´ ......
Comparison of SQL and MDX Syntax
The Multidimensional Expressions (MDX) syntax is similar to the syntax of Structured Query Language (SQL). In many ways, the functionality supplied by MDX is also similar to that of SQL; with effort, you can eve ......
°²×°Ç°×¼±¸£º
Ç°ÑÔ£º
¡¡¡¡[ѧϰSQL SERVER 2005ϵÁÐ]×¼±¸°Ñѧϰ2005µÄһЩÐĵÃÕûÀí³öÀ´£¬ºÍ´ó¼Ò·ÖÏí£¬¹²Í¬Ñ§Ï°Ò»ÆðÌá¸ß¡£
°²×°×¼±¸£º
1¡¢SQL Server 2005 µÄ¸÷°æ±¾Ö®¼äÑ¡Ôñ
¡¡¡¡´ó¶àÊýÆóÒµ¶¼ÔÚÈý¸ö SQL Server °æ±¾Ö®¼äÑ¡Ôñ£ºSQL Server 2005 Enterprise Edition¡¢SQL Server 2005 Standard Edition ºÍ SQL Server 2 ......