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

¿ìËٸ㶨ÔÚ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 ALL ²Ù×÷·û


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ÓïÑÔ»ù´¡ Êý¾Ý²éѯ

ÔÚSQLÓïÑÔÖУ¬Ö»ÌṩÁËÒ»¸ö¶¯´ÊSELECTÓÃÀ´½øÐÐÊý¾Ý²éѯ²Ù×÷£¬µ«Õâ¸ö¶¯´ÊµÄ²ÎÊýÊ®·Ö¸´ÔÓ£¬ÇÒÄÜǶÌ×ʹÓã¬ÆäͨÓøñʽÈçÏ£º
SELECT [All|Distinct]<Ä¿±êÁбí´ïʽ>[£¬<Ä¿±êÁбí´ïʽ>]...
from <±íÃû»òÊÓͼÃû>[£¬<±íÃû»òÊÓͼÃû>]...
[WHERE<Ìõ¼þ±í´ïʽ>]
[GROUP BY<ÁÐÃû1>[HAVING<Ì ......

SQL Server²éѯÓÅ»¯

MS SQL Server²éѯÓÅ»¯·½·¨
×÷Õߣºxmllover 2007-11-29 
²éѯËÙ¶ÈÂýµÄÔ­ÒòºÜ¶à£¬³£¼ûÈçϼ¸ÖÖ 
  1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ) 
  2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£ 
  3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£ 
  4¡¢ÄÚ´æ ......

Rebuild indexes online with SQL Server 2005

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 ......

VC++µÄADOÁ¬½ÓSQL Server²½Öè

 1£ºSQL  ServerÊý¾Ý¿âÅäÖÃ
 
 
 
¿ªÆô·þÎñÆ÷
 
 
ÍÐÅÌÏÔʾ·þÎñÆ÷Æô¶¯
 
 
 
2:ÔÚStaAfx.h ÖÐÌí¼ÓÈçÏ´úÂë
#import "C:\\Program Files\\Common Files\\System\\ado\\msado15.dll" no_namespace      rename("EOF","adoEOF")rena ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ