°ïæ½éÉÜÒ»±¾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 ϵÁеġ£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
1.´´½¨Ò»¸öÊý¾Ý¿âʱ
ÓдíÂð£¿Ëü×ÜÊÇÌáʾdbd.ldfÒѾ´æÔÚ µ«ÊÇÔõô¸ÄÃû¶¼»¹ÊÇÒ»ÑùÌáʾ´æÔÚ
create database testdb
on primary
(name=db1,filename='e:\java\zy\dba.mdf',size=1,maxsize=5,file ......
±íÃû:ABC
select * from abc ÌáʾÕÒ²»µ½¶ÔÏó
select * from ABC ÕýÈ·.
Õâ¸ö´óСдÔÚÄÄÀïÉèÖõÄ?
ÒÔǰ½¨µÄ¿âµ¹Ã»Õâ¸öÎÊÌâ.ºóÔÚ±¾ÉíÖØÐ½¨Á¢Ò»Ð¿â.ÓÉÓÚ³ÌÐòÖлù±¾ÉÏȫΪСд.³ÌÐòÎÞ·¨ÔËÐÐ.È«ÊÇ´íÎóÌá ......