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

sqlÓï¾ä¼¯ºÏ

A¡£
SQLÓï¾äµÄ²¢¼¯UNION£¬½»¼¯JOIN(ÄÚÁ¬½Ó£¬ÍâÁ¬½Ó)£¬½»²æÁ¬½Ó(CROSS
JOINµÑ¿¨¶û»ý)£¬²î¼¯(NOT IN)
1.
a. ²¢¼¯UNION
SELECT column1, column2 from table1
UNION
SELECT column1, column2 from table2
b. ½»¼¯JOIN
SELECT * from table1 AS a JOIN table2 b ON a.name=b.name
c. ²î¼¯NOT IN
SELECT * from table1 WHERE name NOT IN(SELECT name from table2)
d. µÑ¿¨¶û»ý
SELECT * from table1 CROSS JOIN table2
Óë
SELECT * from table1,table2Ïàͬ
2. SQLÖеÄUNION
UNIONÓëUNION ALLµÄÇø±ðÊÇ£¬Ç°Õß»áÈ¥³ýÖØ¸´µÄÌõÄ¿£¬ºóÕß»áÈԾɱ£Áô¡£
a. UNION
SQL Statement1
UNION
SQL Statement2
b. UNION ALL
SQL Statement1
UNION ALL
SQL Statement2
3. SQLÖеĸ÷ÖÖJOIN
SQLÖеÄÁ¬½Ó¿ÉÒÔ·ÖΪÄÚÁ¬½Ó£¬ÍâÁ¬½Ó£¬ÒÔ¼°½»²æÁ¬½Ó
(¼´Êǵѿ¨¶û»ý)
a. ½»²æÁ¬½ÓCROSS JOIN
Èç¹û²»´øWHEREÌõ¼þ×Ӿ䣬Ëü½«»á·µ»Ø±»Á¬½ÓµÄÁ½¸ö±íµÄµÑ¿¨¶û»ý£¬·µ»Ø½á¹ûµÄÐÐÊýµÈÓÚÁ½¸ö±íÐÐÊýµÄ³Ë»ý£»
¾ÙÀý
SELECT * from table1 CROSS JOIN table2
µÈͬÓÚ
SELECT * from table1,table2
Ò»°ã²»½¨ÒéʹÓø÷½·¨£¬ÒòΪÈç¹ûÓÐWHERE×Ó¾äµÄ»°£¬ÍùÍù»áÏÈÉú³ÉÁ½¸ö±íÐÐÊý³Ë»ýµÄÐеÄÊý¾Ý±íÈ»ºó²Å¸ù¾ÝWHEREÌõ¼þ´ÓÖÐÑ¡Ôñ¡£

Òò´Ë£¬Èç¹ûÁ½¸öÐèÒªÇ󽻼ʵıíÌ«´ó£¬½«»á·Ç³£·Ç³£Âý£¬²»½¨ÒéʹÓá£
b. ÄÚÁ¬½ÓINNER JOIN
Èç¹û½ö½öʹÓÃ
SELECT * from table1 INNER JOIN table2
ûÓÐÖ¸¶¨Á¬½ÓÌõ¼þµÄ»°£¬ºÍ½»²æÁ¬½ÓµÄ½á¹ûÒ»Ñù¡£
µ«ÊÇͨ³£Çé¿öÏ£¬Ê¹ÓÃINNER JOINÐèÒªÖ¸¶¨Á¬½ÓÌõ¼þ¡£
-- µÈÖµÁ¬½Ó(=ºÅÓ¦ÓÃÓÚÁ¬½ÓÌõ¼þ, ²»»áÈ¥³ýÖØ¸´µÄÁÐ)
SELECT * from table1 AS a INNER JOIN table2 AS b on a.column=b.column
-- ²»µÈÁ¬½Ó(>,>=,<,<=,!>,!<,<>)
ÀýÈç
SELECT * from table1 AS a INNER JOIN table2 AS b on
a.column<>b.column
-- ×ÔÈ»Á¬½Ó(»áÈ¥³ýÖØ¸´µÄÁÐ)
c. ÍâÁ¬½ÓOUTER JOIN
Ê×ÏÈÄÚÁ¬½ÓºÍÍâÁ¬½ÓµÄ²»Í¬Ö®´¦£º
ÄÚÁ¬½ÓÈç¹ûûÓÐÖ¸¶¨Á¬½ÓÌõ¼þµÄ»°£¬ºÍµÑ¿¨¶û»ýµÄ½»²æÁ¬½Ó½á¹ûÒ»Ñù£¬µ«ÊDz»Í¬Óڵѿ¨¶û»ýµÄµØ·½ÊÇ£¬Ã»Óеѿ¨¶û»ýÄÇô¸´ÔÓÒªÏÈÉú³ÉÐÐÊý³Ë
»ýµÄÊý¾Ý±í£¬ÄÚÁ¬½ÓµÄЧÂÊÒª¸ßÓڵѿ¨¶û»ýµÄ½»²æÁ¬½Ó¡£
Ö¸¶¨Ìõ¼þµÄÄÚÁ¬½Ó£¬½ö½ö·µ»Ø·ûºÏÁ¬½ÓÌõ¼þµÄÌõÄ¿¡£
ÍâÁ¬½ÓÔò²»Í¬£¬·µ»ØµÄ½á¹û²»½ö°üº¬·ûºÏÁ¬½ÓÌõ¼þµÄÐУ¬¶øÇÒ°üÀ¨×ó±í(×óÍâÁ¬½Óʱ),
ÓÒ±í(ÓÒÁ¬½Óʱ)»òÕßÁ½±ßÁ¬½Ó(È«ÍâÁ¬½Óʱ)µÄËùÓÐÊý¾ÝÐС£
1)×óÍâÁ¬½ÓLEFT [OUTER] JOI


Ïà¹ØÎĵµ£º

sql ʱ¼ä¸ñʽת»»

Óï¾ä¼°²éѯ½á¹û£º
SELECT CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
SELECT CONVERT(varchar(100), GETDATE(), 1): 05/16/06
SELECT CONVERT(varchar(100), GETDATE(), 2): 06.05.16
SELECT CONVERT(varchar(100), GETDATE(), 3): 16/05/06
SELECT CONVERT(varchar(100), GETDATE(), 4): 16.05.06
SE ......

SqlHelper.csÔ´´úÂë petshop4.0 sql server helperÀà

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Collections;
using System.Data.SqlClient;
/// <summary>
/// Êý¾Ý¿âµÄͨÓ÷ÃÎÊ´úÂë
/// ´ËÀàΪ³éÏóÀ࣬²»ÔÊÐíʵÀý»¯£¬ÔÚÓ¦ÓÃʱֱ½Óµ÷Óü´¿É
/// </summary>
public ab ......

SQL SERVER 2005 ÈçºÎÆô¶¯·þÎñ

1.¡¸¿ªÊ¼¡¹²Ëµ¥->ÔËÐÐ
--Æô¶¯sql server 2005 ·þÎñ
net start mssqlserver
--Í£Ö¹sql server 2005 ·þÎñ
net stop mssqlserver
2.¡¸¿ªÊ¼¡¹²Ëµ¥->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß
SQL Server Configuration Manager->SQL Server(MSSQLSERVER) ÓÒ»÷ Æô¶¯·þÎñ³É¹¦ºó£¬×´Ì¬ÏÔʾΪ“ÕýÔÚÔËÐ ......

SQL Server 2000µÄÊý¾Ý¿âÈÝÁ¿

-->Ŀ¼
-->SQL Server ¹¹¼Ü
-->ʵʩϸÔò
-->×î´óÈÝÁ¿ËµÃ÷
 
×î´óÖµ£¨ÊýÁ¿»ò´óС£©
¶ÔÏó SQL Server 7.0 SQL Server 2000
Åú´¦Àí´óС 65,536 * ÍøÂçÊý¾Ý°ü´óС1 65,536 * ÍøÂçÊý¾Ý°ü´óС1
ÿ¸ö¶Ì×Ö·û´®ÁеÄ×Ö½ÚÊý 8,000 8,000
ÿ¸ö text¡¢ntext¡¢»ò image ÁеÄ×Ö½ÚÊý 2 GB£­2 2 GB£­2
ÿ¸ö GROU ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ