¿ìËٸ㶨ÔÚEclipseÖÐÓÃJDBCÁ¬½ÓSQL Server 2005
1¡¢ÏÂÔرر¸Èí¼þ
(1) JDK (Java Development Kit)
SUN¹Ù·½µÄÏÂÔصØÖ·ÊÇhttp://java.sun.com/javase/downloads/index.jsp
(2) JDBC
(3) Eclipse
(4) Microsoft SQL Server 2005 Express£¨µ±È»£¬ÓзÇExpressÒ²OK°¡£©
(5) SQL Server Management Studio
2¡¢°²×°Óë»·¾³ÅäÖÃ
(1) JDK
Ê×ÏÈÔÚWindows»·¾³Ï£¬ÏÂÔغó°²×°¼´¿É¡£
È»ºóÔÚÎҵĵçÄÔ-ÊôÐÔ-¸ß¼¶ÏµÍ³ÉèÖÃ-¸ß¼¶-»·¾³±äÁ¿-ϵͳ±äÁ¿£º
1¡¢“н¨”£º±äÁ¿ÃûΪJAVA_HOME£¬±äÁ¿ÖµÎªJDKµÄ¸ùĿ¼¡£
2¡¢“н¨”£º±äÁ¿ÃûΪCLASSPATH£¬±äÁ¿ÖµÎª%JAVA_HOME%\lib
3¡¢“н¨”£º±äÁ¿ÃûΪPATH£¬±äÁ¿ÖµÎª%JAVA_HOME%\bin
×¢Ò⣺Èç¹û±äÁ¿ÃûÒѾ´æÔÚ£¬ÔòÑ¡Ôñ“±à¼”£¬ÔÚ±äÁ¿ÖµµÄ×îºó¼ÓÉÏ“;”£¨·ÖºÅ£©£¬²¢ÔڷֺźóÃæÊäÈëÉÏÃæËùÊöµÄ±äÁ¿Öµ¡£
×îºó±ðÍüÁ˵ã“È·¶¨”¡£ÏÖÔھͿÉÒÔÔÚÃüÁîÐÐÖÐʹÓÓjavac”ÁË¡£
(2) JDBC
ÏÂÔغó½âѹ£¬ÔÚ°²×°Ä¿Â¼ÕÒµ½sqljdbc.jar£¨×¢Ò⣬Ä㻹»áÕÒµ½Ò»¸ösqljdbc4.jar£¬¿¼Âǵ½ÓеÄjre°æ±¾µÍµÄÇé¿ö£¬Ö»ÓÃsqljdbc.jar£¬²»ÓÃsqljdbc4.jar£©¡£
¼ÆËã»ú->ÊôÐÔ->¸ß¼¶->»·¾³±äÁ¿->ϵͳ±äÁ¿->classpath×îºó×·¼ÓÕâ¸ösqljdbc.jar£¬Ò»¶¨ÒªÐ´ÍêÕûµÄ·¾¶£¬´ÓÅÌ·û¿ªÊ¼¡£
Ñ¡ÔñÈ·¶¨¡£
(3) SQL Server Configuration Management
¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->SQL Server Configuration Management
->SQLEXPRESSµÄÐÒé->ÓÒ¼üTCP/IP£¬Ñ¡ÔñÆô¶¯£»
->SQLEXPRESSµÄÐÒé->Ë«»÷TCP/IP£¬°ÑIPµØÖ·Ñ¡ÏÖеÄIPALLÖеÄTCP¶Ë¿ÚÉèÖÃΪÄãËùÏëÒªÉèÖõĶ˿ڣ¬Èç1433£»
ÖØÐÂÆô¶¯SQL Server·þÎñ
¹Ø±ÕSQL Server Configuration Management
(4) SQL Server Management Studio
н¨Êý¾Ý¿â£¬Ãû³Æ¿É¶¨Îªsample
(5) Eclipse
File->New->java project£¬Ãû³Æ×Ô¶¨£»
Window->Preferences->Java->Installed JREs->Ñ¡Ôñjre6->Edit->Add Extenal JARs->Ñ¡Ôñsqljdbc.jarµÄλÖá£
3¡¢²Î¿¼×ÊÁÏ£º
¡¾1¡¿http://wenku.baidu.com/view/19967d1b6bd97f192279e9a5.html
¡¾2¡¿http://blog.csdn.net/Poechant/archive/2010/05/31/5635542.aspx
¡¾3¡¿http://blog.sina.com.cn/s/blog_5ccc0a650100he46.html
¡¾4¡¿http://blog.csdn.net/downmoon/archive/2009/07/16/4352914.aspx
Ïà¹ØÎĵµ£º
SQL UNION ²Ù×÷·û
UNION ²Ù×÷·ûÓÃÓںϲ¢Á½¸ö»ò¶à¸ö SELECT Óï¾äµÄ½á¹û¼¯¡£
Çë×¢Ò⣬UNION ÄÚ²¿µÄ SELECT Óï¾ä±ØÐëÓµÓÐÏàͬÊýÁ¿µÄÁС£ÁÐÒ²±ØÐëÓµÓÐÏàËƵÄÊý¾ÝÀàÐÍ¡£Í¬Ê±£¬Ã¿Ìõ SELECT Óï¾äÖеÄÁеÄ˳Ðò±ØÐëÏàͬ¡£
SQL UNION Óï·¨
SELECT column_name(s) from table_name1
UNION
SELECT column_name(s) from table_na ......
ÔÚSQLÓïÑÔÖУ¬Ö»ÌṩÁËÒ»¸ö¶¯´ÊSELECTÓÃÀ´½øÐÐÊý¾Ý²éѯ²Ù×÷£¬µ«Õâ¸ö¶¯´ÊµÄ²ÎÊýÊ®·Ö¸´ÔÓ£¬ÇÒÄÜǶÌ×ʹÓã¬ÆäͨÓøñʽÈçÏ£º
SELECT [All|Distinct]<Ä¿±êÁбí´ïʽ>[£¬<Ä¿±êÁбí´ïʽ>]...
from <±íÃû»òÊÓͼÃû>[£¬<±íÃû»òÊÓͼÃû>]...
[WHERE<Ìõ¼þ±í´ïʽ>]
[GROUP BY<ÁÐÃû1>[HAVING<Ì ......
MS SQL Server²éѯÓÅ»¯·½·¨
×÷Õߣºxmllover 2007-11-29
²éѯËÙ¶ÈÂýµÄÔÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ
1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)
2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£
4¡¢ÄÚ´æ ......
Rebuild indexes online with SQL Server 2005
http://blogs.techrepublic.com.com/datacenter/?p=249
Online index rebuild
SQL Server 2005 introduces the ability to rebuild your indexes in an
online fashion so that other processes are able to access the table
while the rebuild is occurring. Because y ......
1£ºSQL ServerÊý¾Ý¿âÅäÖÃ
¿ªÆô·þÎñÆ÷
ÍÐÅÌÏÔʾ·þÎñÆ÷Æô¶¯
2:ÔÚStaAfx.h ÖÐÌí¼ÓÈçÏ´úÂë
#import "C:\\Program Files\\Common Files\\System\\ado\\msado15.dll" no_namespace rename("EOF","adoEOF")rena ......