SQL IN ת»¯Îª EXISTS µÄ·½·¨
·Ï»°ÉÙ˵,(ÒѾÓоä·Ï»°ÁË.)
¿´±í
Óï¾ä: SELECT * from C
//---------------------------------------
Cno Cname Teacher
---- ---------- --------
1 ÓïÎÄ Æî¾²
2 Êýѧ ÕÅÎĸ»
3 Ó¢Óï Àõ°®·ï
(3 ÐÐÊÜÓ°Ïì)
//---------------------------------------
Óï¾ä: SELECT * from S
//---------------------------------------
Sno Sname Ssex Sage Address
-------- -------- ---- ------ --------------------
09001 ÕÅÈý ÄÐ 15 μ±õ
09002 ÀîËÄ Å® 15 ½ð̨
09003 ÍõÎå Å® 16 ·ïÏè
09004 ÕÔÁù ÄÐ 14 ·ïÏè
09005 ÍõÂé×Ó Å® 17 ³Â²Ö
09020 ÕÅÈýÈý ÄÐ 25 ±¦¼¦
(6 ÐÐÊÜÓ°Ïì)
//---------------------------------------
Óï¾ä: SELECT * from SC
//---------------------------------------
Sno Cno Grade
-------- ---- -----------
09001 1 2
09002 2 3
09001 2 35
09004 3 45
09005 3 45
09003 3 65
09003 1 42
090
Ïà¹ØÎĵµ£º
ÓÉÓÚÊý¾Ý¿â¶ÔxmlÊý¾ÝÖ±½Ó´¦ÀíÓкܶàÓÅÊÆ£¬05Ò²¶ÔÕâ·½Ãæ¼ÓÇ¿Á˹¦ÄÜ¡£
µ«Õâ·½Ãæ×ÊÁÏÉÙ£¬ËùÒÔ×Ô¼º×öÁËһЩ×ܽᣬϣÍû»á¸ø´ó¼Ò´øÀ´°ïÖú
--charry0110(Ïþ·ç²ÐÔÂ)
--×÷Õߣº³Â ......
¶¨Òå±êÁ¿±äÁ¿Óï·¨
ÔÚPL/SQLÓï¿éÖж¨Òå±äÁ¿ºÍ³£Á¿µÄÓï·¨ÈçÏÂ
indentifier [CONSTANT] datatype [NOT NULL] [:=|DEFAULT expr]
indentifier ÓÃÓÚÖ¸¶¨±äÁ¿»ò³£Á¿µÄÃû³Æ
CONSTANT:ÓÃÓÚÖ¸¶¨³£Á¿¡£µ±¶¨Òå³£Á¿Ê±£¬±ØÐëÖ¸¶¨ËüµÄ³õʼֵ£¬²¢ÇÒÆäÊýÖµ²»Äܸıä
datatype£ºÓÃÓÚÖ¸¶¨±äÁ¿»ò³£Á¿µÄÊý¾ÝÀàÐÍ¡£
NOT NULL£º ÓÃÓÚÇ¿ ......
Ò»¡¢É¶ÊÇsql×¢Èë
Ëùνsql×¢Èë¼òµ¥Ëµ¾ÍÊDZ»ÈË×êÁËSQLµÄ¿Õ×ÓÏÂÃæ¾Ù¸ö×î¼òµ¥µÄÀý×Ó¡£
sql Ϊ£º"select * from users where username='"+userName+"' and password='"+password+"' "
1¡¢¹¥»÷ÕßÖ»ÒªÔÚ´«ÈëµÄuserName¼ÓÉÏ'--ÉÏÃæµÄsql±ã½« ......
ÔÚжÔØVisual Studio 2008 ʱ£¬Ìí¼Ó/ɾ³ý³ÌÐò ÀïÃæÓÐÐí¶àµÄ°²×°Îļþ£¬´ËʱÈç¹ûûÓÐÏÈжÔØSQL Server 2005 £¬
¶øÏÈжÔØ.Net Framework£¨Ìáʾ£ºÐ¶ÔØ.net FrameworkµÄµÃ°²°æ±¾´Ó¸ßµ½µÍµÄ˳Ðò£©£¬
ÕâʱSQL Server 2005¾ÍÎÞ·¨Ð¶ÔØ,ɾ³ýProgram files ÏÂÃæµÄ Microsoft SQL Server Îļþ¼ÐҲûÓÐ×÷Óá£
ÖØа²×°ÌáʾÊý¾Ý¿ ......