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

°ïæ½éÉÜÒ»±¾sql 2005µÄÊé

ÒÔǰÔÚѧУѧµÄÊDZʼǻù´¡µÄ½Ì³Ì
ÏëÂò±¾sql 2005·½ÃæµÄÊéÏ£ÍûÉÏÃæÀýÌâ±È½Ï¶à£¬½²µÄÄÜÏêϸµã
֪ʶµãҪȫ
ÎÒÒ²ÏëÖªµÀ.

ÖåÀÏ´óµÄÊé

jf

Áº¸çÄãÄÇôţ¶¼ÄܳöÊéÁË¡£¡£¡£

ÉîÈëdz³öSQL 2005¿ª·¢¡¢¹ÜÀíÓëÓ¦ÓÃʵÀý

http://product.dangdang.com/product.aspx?product_id=20228858
Õâ±¾ÊéÈçºÎ°¡¡£¡£¡£

×ÞÀÏ´óµÄÊ黹ҪÐÞÁ¶Ò»¶Îʱ¼äÔÙÑо¿

ÆäʵmsdnÉÏÃæµÄÁ·Ï°¸ú×Å×öÒ»±éÓÃÐĵãÒ²¾Í²î²»¶àÁË

http://search.book.dangdang.com/search.aspx?key=%C9%EE%C8%EB%C7%B3%B3%F6SQL+2005%BF%AA%B7%A2%A1%A2%B9%DC%C0%ED%D3%EB%D3%A6%D3%C3%CA%B5%C0%FD&catalog=01&SearchfromTop=1

ÀÏ´óµÄÊé Ö±½Ó¿´ ²»ÐèÒªÐÞÁ¶  Ò»¿ªÊ¼¾ÍÄѵãºÃЩ

ÕÂÁ¢ÃñµÄ¡¶SQL SERVER 2005Êý¾Ý¿â¿ª·¢ÊµÕ½¡·ÕâÊÇÒ»±¾ºÜºÃµÄÊ飬ºÜ¶àʵÀý

ѧÊý¾Ý¿â£¬×îºÃ¿´ÍâÎÄ¡£ÌرðÊÇinsde microsoft ϵÁеġ£


Ïà¹ØÎÊ´ð£º

pl/sqlµ¼ÈëÊý¾ÝÎÊÌâ

ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç  "2009-01","8949-232"

½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

sql ²éѯ

  ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ

ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......

sql²éѯÒÉÎÊ

±íÖа´datadate,tradeidΪÖ÷¼ü£¬Ò²¾ÍÊÇ˵tradeid»áÖØ¸´³öÏÖÔÚ²»Í¬ÌìÖУ¬Í¬Ò»ÌìµÄtradeidÊDz»Í¬µÄ¡£ÏÖÔÚÎÒÏ£Íûȡһ¶Îʱ¼ä·¶Î§ÄÚ²»Öظ´µÄtradeid£¬ÇÒֻҪÿ¸ötradeidµÄ×îºóÒ»´Î³öÏÖµÄÄÇÌõ¡£sqlÓï¾ä¸ÃÔõôд

£º ......

¾«ÃîSQL語¾ä

SQL code:
1. ˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ£¬Ô´±íÃû£ºa£¬Ð±íÃû£ºb)
SQL: select * into b from a where 1<>1;
2. ˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý£¬Ô´±íÃû£ºa£¬Ä¿±ê±íÃû£ºb)
SQL: insert into b(a ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ