SQLÓï·¨,SQLÓï¾ä´óÈ«,SQL»ù´¡
£Ó£Ñ£Ì Óï·¨²Î¿¼ÊÖ²á(SQL)/Êý¾ÝÀàÐÍ
2006-07-24 07:42
¡¶£Ó£Ñ£Ì Óï·¨²Î¿¼ÊÖ²á(SQL)¡·
DB2 ÌṩÁ˹ØÁ¬Ê½×ÊÁÏ¿âµÄ²éѯÓïÑÔ £Ó£Ñ£Ì (Structured Query Language)£¬ÊÇÒ»Öַdz£¿ÚÓﻯ¡¢¼ÈÒ×ѧÓÖÒ×¶®µÄÓï·¨¡£´ËÒ»ÓïÑÔ¼¸ºõÊÇÿ¸ö×ÊÁÏ¿âϵͳ¶¼±ØÐëÌṩµÄ£¬ÓÃÒÔ±íʾ¹ØÁ¬Ê½µÄ*×÷£¬°üº¬ÁË×ÊÁϵ͍Ò壨£Ä£Ä£Ì£©ÒÔ¼°×ÊÁϵĴ¦Àí£¨£Ä£Í£Ì£©¡£SQLÔÀ´Æ´³ÉSEQUEL£¬ÕâÓïÑÔµÄÔÐÍÒԓϵͳ R“µÄÃû×ÖÔÚ IBM Ê¥ºÉÎ÷ʵÑéÊÒÍê³É£¬¾¹ýIBMÄÚ²¿¼°ÆäËûµÄÐí¶àʹÓÃÐÔ¼°Ð§ÂʲâÊÔ£¬Æä½á¹ûÏ൱ÁîÈËÂúÒ⣬²¢¾ö¶¨ÔÚϵͳR µÄ¼¼Êõ»ù´¡·¢Õ¹³öÀ´ IBM µÄ²úÆ·¡£¶øÇÒÃÀ¹ú¹ú¼Ò±ê׼ѧ»á£¨ANSI£©¼°¹ú¼Ê±ê×¼»¯×éÖ¯£¨ISO£©ÔÚ1987×ñÑÒ»¸ö¼¸ºõÊÇÒÔ IBM SQL Ϊ»ù´¡µÄ±ê×¼¹ØÁ¬Ê½×ÊÁÏÓïÑÔ¶¨Òå¡£
Ò»¡¢×ÊÁ϶¨Òå £Ä£Ä£Ì£¨Data Definition Language)
×ÊÁ϶¨ÓïÑÔÊÇÖ¸¶Ô×ÊÁϵĸñʽºÍÐÎ̬϶¨ÒåµÄÓïÑÔ£¬ËûÊÇÿ¸ö×ÊÁÏ¿âÒª½¨Á¢Ê±ºòʱÊ×ÏÈÒªÃæ¶ÔµÄ£¬¾Ù·²×ÊÁÏ·ÖÄÄЩ±í¸ñ¹ØÏµ¡¢±í¸ñÄÚµÄÓÐʲ÷áÀ¸Î»Ö÷¼ü¡¢±í¸ñºÍ±í¸ñÖ®¼ä»¥Ïà²Î¿¼µÄ¹ØÏµµÈµÈ£¬¶¼ÊÇÔÚ¿ªÊ¼µÄʱºòËù±ØÐë¹æ»®ºÃµÄ¡£
£±¡¢½¨±í¸ñ£º
Create TABLE table_name(
column1 DATATYPE [NOT NULL] [NOT NULL PRIMARY KEY],
column2 DATATYPE [NOT NULL],
...£©
˵Ã÷£º¡¡
DATATYPE --ÊÇ×ÊÁϵĸñʽ£¬Ïê¼û±í¡£
NUT NULL --¿É²»¿ÉÒÔÔÊÐí×ÊÁÏÓпյģ¨ÉÐδÓÐ×ÊÁÏÌîÈ룩¡£
PRIMARY KEY --ÊDZ¾±íµÄÖ÷¼ü¡£
£²¡¢¸ü¸Ä±í¸ñ¡¡
Alter TABLE table_name
ADD COLUMN column_name DATATYPE
˵Ã÷£ºÔö¼ÓÒ»¸öÀ¸Î»£¨Ã»ÓÐɾ³ýij¸öÀ¸Î»µÄÓï·¨¡£
Alter TABLE table_name
ADD PRIMARY KEY (column_name)
˵Ã÷£º¸ü¸Ä±íµÃµÄ¶¨Òå°Ñij¸öÀ¸Î»ÉèΪÖ÷¼ü¡£
Alter TABLE table_name
Drop PRIMARY KEY (column_name)
˵Ã÷£º°ÑÖ÷¼üµÄ¶¨Òåɾ³ý¡£
£³¡¢½¨Á¢Ë÷Òý¡¡
Create INDEX index_name ON table_name (column_name)
˵Ã÷£º¶Ôij¸ö±í¸ñµÄÀ¸Î»½¨Á¢Ë÷ÒýÒÔÔö¼Ó²éѯʱµÄËÙ¶È¡£
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
ÕªÒª
¶ÔÓÚSQL ServerÖеÄÔ¼Êø£¬Ïë±Ø´ó¼Ò²¢²»ÊǺÜİÉú¡£µ«ÊÇÔ¼ÊøÖÐÕæÕýµÄÄÚºÊÇʲô£¬²¢²»ÊǺܶàÈ˶¼ºÜÇå³þµÄ¡£±¾ÎÄÒÔÏêϸµÄÎÄ×ÖÀ´½éÉÜÁËʲôÊÇÔ¼Êø£¬ÒÔ¼°ÈçºÎÔÚÊý¾Ý¿â±à³ÌÖÐÓ¦ÓúÍʹÓÃÕâÐ©Ô¼Êø£¬À´´ïµ½¸üºÃµÄ±à³ÌЧ¹û¡££¨±¾ÎIJ¿·ÖÄÚÈݲο¼ÁËSQL ServerÁª»úÊֲᣩ
ÄÚÈÝ
Êý¾ÝÍêÕûÐÔ·ÖÀà
ʵÌåÍêÕûÐÔ
&nb ......
´ËÎÊÌâÕÛÌÚ°ëÌì,googleÒ²ËÑË÷ÁË,ÍøÉϺܶàÅóÓÑÒ»°ã×öµ½µÚ¶þ²½²»³É¹¦,ÎÒÒ²²îµã·ÅÆúÁË.×îºóͨ¹ýµÚÈý²½Á¬½Ó³É¹¦ÁË.
1.·À»ðǽÔÊÐí1433
2.ÅäÖù¤¾ßÀïµÄSQL Server ÅäÖùÜÀíÆ÷.´ò¿ªºó,¿ªÆôÓÒ±ßÈý¸öÐÒé.²¢¶Ôtcp/ipÈçÏÂÅäÖÃ
3.ÍøÉϴ󲿷Ö×öµ½µÚ¶þ°æÖØÆôsql server·þÎñ,ÈÔÈ»ÎÞЧ.Æäʵ,ÐèÒªÐÞ¸ÄÁ¬½Ó×Ö·û´®.Ö¸¶¨ÎÒÃÇÅäÖõĶ ......
1 ǰÑÔ
¿Í·þÒµÎñÊܵ½SQLÓï¾äµÄÓ°Ïì·Ç³£´ó£¬ÔÚ¹æÄ£±È½Ï´óµÄ¾Öµã£¬ÍùÍùÒòΪһ¸öСµÄSQLÓï¾ä²»¹»ÓÅ»¯£¬µ¼ÖÂÊý¾Ý¿âÐÔÄܼ±¾çϽµ£¬Ð¡ÐÍ»úidleËùÊ£ÎÞ¼¸£¬Ó¦Ó÷þÎñÆ÷¶ÏÁ¬¡¢³¬Ê±£¬ÑÏÖØÓ°ÏìÒµÎñµÄÕý³£ÔËÐС£Òò´Ë£¬³ÆµÍЧµÄSQLÓï¾äΪ¿Í·þÒµÎñµÄ‘¶ñÁú’²¢²»¹ý·Ö¡£Êý¾Ý¿âµ ......
sql server
Ìæ»»null:isnull(arg,value)
Èç:select isnull(price,0.0) from orders ,Èç¹ûpriceΪnullµÄ»°£¬ÓÃ0 ......