ÊÕ¼¯ÁËһЩ΢ÈísqlÏà¹ØÈÏÖ¤¿¼ÊÔµÄÊÔÌ⼯ºÏ£¬·ÖÏíÒ»ÏÂ
»ìSQL°æÕâô¾ÃÁË£¬·ÖÏíÒ»µã×ÊÁÏ
sql serverµÄÏà¹ØÈÏÖ¤µÄÊÔÌ⼯ºÏ£¬°æÓÑÓл¹ÔÚѧУµÄ»°¾ÍÏÂÔØÏÂÀ´Óлú»á¿¼ÊÔһϣ¬±Ï¾¹350Ôª´ó¼Ò»¹ÊǸºµ£µÃÆðµÄ£¬½«À´±ÏÒµºóÒ²ÊÇÒ»¸öºÃÒ»µãµÄÖ¤ÊéÖ¤Ã÷
Èç¹û×¼±¸×¨×¢ÓÚÕâ·½Ãæ¹¤×÷µÄ»°Ò²¿ÉÒÔ¿´¿´£¬ËäÈ»Óеã¹ý·ÖÀíÂÛ»¯£¬µ«ÊÇ¿ÉÒÔÈÃ×Ô¼ºÖªÊ¶¸ü¼Óϵͳ»¯Ò»Ð©£¬»áÓÐһЩÊÕ»ñµÄ
ÕûÀíÁËËùÓÐÊÕ¼¯µ½µÄ·ÅÔÚcsdn download£¬
http://7761098.download.csdn.net/
²»¹ý¿ÉÄܺܶಿ·ÖÏÖÔÚ»¹ÔÚÉóºË£¬Ó¦¸ÃÕ⼸Ìì¶¼»á²¹ÆëµÄ¡£´ó¼Ò²Î¿¼Ò»Ï¾ͺÃÁË£¬Ö»ÊÇ×ÊÁÏ·ÖÏí¶øÒÑ
70-431 TS Microsoft SQL Server 2005 - Implementation and Maintenance
70-432 TS Microsoft SQL Server 2008, Implementation and Maintenance
70-433 TS Microsoft SQL Server 2008, Database Development
70-441 PRO Designing Database Solutions by Using Microsoft SQL Server 2005
70-442 PRO Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
70-443 PRO Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005
70-444 PRO Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005
70-445 TS Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance
70-446 PRO Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005
70-447 UPGRADE MCDBA Skills to MCITP Database Administrator by Using Microsoft SQL Server 2005
70-448 TS Microsoft SQL Server 2008, Bu
Ïà¹ØÎÊ´ð£º
ÎÒ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
Ö¸µ ......
SQL code:
1. ˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ£¬Ô´±íÃû£ºa£¬Ð±íÃû£ºb)
SQL: select * into b from a where 1<>1;
2. ˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý£¬Ô´±íÃû£ºa£¬Ä¿±ê±íÃû£ºb)
SQL: insert into b(a ......
Óï¾äÈçÏ£¬ÆäÖÐ×Ö¶ÎÃû´æ´¢µÄÊÇÍøÖ·£¬Õû¸ö´úÂëµÄ¹¦ÄܾÍÊÇͳ¼ÆÏàÍ¬ÍøÕ¾µÄ´ÎÊý£¬
±ÈÈç˵ÓÐÁ½Ìõ¼Ç¼,Ò»¸öÊÇhttp://www.baidu.com/ ÁíÒ»¸öÊÇhttp://www.baidu.com/a/b/c/d/
Õâ¶Î´úÂë¾Í»á°´ÕÕµãºÅ".&quo ......