Á¬½ÓSQL server2005Êý¾Ý¿â¶Ë1433¶Ë¿ÚµÄÕýÈ··½·¨¡£
½ñÌì×°ÁËSQL server2005Êý¾Ý¿â£¬Íê³ÉºóÁ¬½Ó¶Ë¿Ú1433ʱʧ°ÜÁË£¬µÚÒ»´Î°²×°µÄʱºò£¬Ã»ÓаѻúÆ÷ÖеÄSQL server2000Êý¾Ý¿âжÔصô£¬È»ºóжÔØ—>°²×°—>Á¬½Ó,»¹ÊÇʧ°Ü¡£ÓÚÊÇÏÂÃæ¾Í¿ªÊ¼ÅŲ顢µ÷ÊÔÒÔ¼°ÖØ×°SQL server2005Êý¾Ý¿â³ÌÐò£¬ÕûÁË¿ìÒ»Ì죬ÖÕÓÚÔÚÏ°àµÄʱºòÁ¬½Ó³É¹¦¡£
ÏÖÔÚ°ÑÔÚ×°Íê³ÌÐòºó£¬Á¬½Ó¶Ë¿Ú1433Ç°£¬Òª×öµÄ¼¸¼þÊÂÇéºÍ×¢ÒâÊÂÏî×ܽáһϡ£
²½Ö裺
1.¹Ø±ÕÊý¾Ý¿âÒýÇæ,¹Ø±ÕÊý¾Ý¿âÒýÇæÓÐÈýÖÖ·½·¨£º
(1)¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server 2005ÍâΧӦÓÃÅäÖÃÆ÷,ÔÚ´ò¿ªµÄ½çÃæµ¥»÷"·þÎñµÄÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷",ÔÚ´ò¿ªµÄ½çÃæÖÐÕÒµ½Database Engine,µ¥»÷"·þÎñ",ÔÚÓÒ²à²é¿´ÊÇ·ñÒÑÆô¶¯,Èç¹ûÒÑÆô¶¯¿Éµ¥»÷“Í£Ö¹”°´Å¥£¬¼´¿É¹Ø±ÕÊý¾Ý¿âÒýÇæ¡£
(2)¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server Configuration Manager,Ñ¡ÖÐSQL Server 2005·þÎñÖÐSQL Server(MSSQLSERVER) ,²¢Ñ¡ÖÐÓÒ»÷,µã»÷Í£Ö¹£¬ ¼´¿É¹Ø±ÕÊý¾Ý¿âÒýÇæ¡£
(3) ¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005-> SQL Server Management Studio£¬ÔÚµ¯³öµÄÁ¬½ÓÊý¾Ý¿âÒýÇæ¶Ô»°¿òÖеã»÷“Á¬½Ó”°´Å¥£¬È»ºóÑ¡ÖзþÎñÆ÷Ãû³Æ£¬ÓÒ»÷“Í£Ö¹”°´Å¥£¬¼´¿É¹Ø±ÕÊý¾Ý¿âÒýÇæ¡£
²¹³ä×¢Òâµã:
ÓÐʱºòÔÚÆô¶¯Êý¾Ý¿âÒýÇæµÄʱºò¿ÉÄÜ»á³öÏÖ´íÎó,²»ÄÜÆô¶¯,Õâʱ¾ÍÒª²é¿´"SQL Server 2005ÅäÖùÜÀíÆ÷"ÖеÄSQL Server 2005ÍøÂçÅäÖÃ->MSSQLSERVERÐÒéÖеÄVIAÊÇ·ñÒÑÆôÓÃ,Èç¹ûÒÑÆôÓÃ,Ôò°ÑËü½ûÖ¹.È»ºóÔÙÖ´ÐÐÉÏÊöÒ»ÖÖ·½Ê½²Ù×÷¾Í¿ÉÒÔÁË.
2.ÅäÖ÷þÎñÆ÷¶ËºÍ¿Í»§¶ËµÄTCP/IPÐÒ飺
ÅäÖù¤¾ß->SQL Server Configuration Manager->MSSQLSERVERµÄÐÒé
¿´¿´TCP/IPÐÒéÊÇ·ñÆô¶¯,Èç¹ûÆô¶¯,ÓÒ¼ü²Ëµ¥µã"ÊôÐÔ" ,ÔÚ·ÖÒ³²Ëµ¥ÖÐÑ¡"IPµØÖ·",°Ñ"IP1"ºÍ"IP2"ÖÐ"TCP¶Ë¿Ú"Ϊ1433,"ÒÑÆôÓÃ"¸ÄΪ"ÊÇ"
ÅäÖù¤¾ß->SQL Server Configuration Manager->SQL Native Client ÅäÖÃ->¿Í»§¶ËÐÒé->TCP/IP
Ñ¡ÔñTCP/IPÓÒ¼ü²Ëµ¥ÖÐ"ÊôÐÔ",È·ÈÏ"ĬÈ϶˿Ú"ÊÇ1433,"ÒÑÆôÓÃ"Ϊ"ÊÇ"
3.¿ªÆôÊý¾Ý¿âÒýÇ棬·½·¨²Î¿¼²½Öè1Öеģ¨1£©¡¢£¨2£©Á½µã¡£
4.Á¬½Ó¶Ë¿Ú1433
¿ªÊ¼–>ÊäÈëcmd –>»Ø³µ–>telnet localhost 433->»Ø³µ
³öÏÖºÚÆÁ£¬±íʾ±¾»úÁ¬½Ó¶Ë¿Ú1433³É¹¦
Ç°¼¸´Î£¬Á¬½Ó¶Ë¿Ú1433ʧ°ÜµÄÔÒòÖ÷ÒªÊÇÔÚÅäÖ÷þÎñÆ÷¶ËºÍ¿Í»§¶ËµÄTC
Ïà¹ØÎĵµ£º
index.jsp
<%@ page language="java" import="java.sql.*" import="java.lang.*" import="java.util.*" pageEncoding="GB2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%!
& ......
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
×÷Õß: ÈýÊ®¶øÁ¢Ê±¼ä£º2009Äê10ÔÂ15ÈÕ 21:59:51±¾Îijö×Ô ¡°inthirties£¨ÈýÊ®¶øÁ¢£©¡±²©¿Í£¬×ªÔØÇëÎñ±Ø×¢Ã÷×÷Õߺͱ£Áô³ö´¦http://blog.csdn.net/inthirties/archive/2009/10/15/4673268.aspx °Ñ´ÎÐò²»¶ÔµÄÁÐÕÒ³öÀ´ ÇëÎÊ ÏÂÃæµÄ±í¸ÃÈçºÎÅÅÐò£¿ÎÒÓÐÏÂÃæµÄ±í¡£´ÎÐòÈçÏ ÆäÖеÚ5¸ö¼Ç¼ºÍµÚ6Ìõ¼Ç¼´ÎÐòµßµ¹ÁË¡£Õâ¸ö±íÊý¾ÝÁ¿±È½Ï ......
Select * into customers from clients
(Êǽ«clients±íÀïµÄ¼Ç¼²åÈëµ½customersÖУ¬ÒªÇó£ºcustomers±í²»´æÔÚ£¬ÒòΪÔÚ²åÈëʱ»á×Ô¶¯´´½¨Ëü£»)
Insert into customers select * from clients
½â£ºInsert into customers select * from clients£©ÒªÇóÄ¿±ê±í£¨customers£©´æÔÚ£¬
ÓÉÓÚÄ¿±ê±íÒѾ´æÔÚ£¬ËùÒÔÎÒÃdzýÁ˲åÈëÔ´±í£ ......
ÕâÊÇÎÒ±ßѧ±ß×ܽáµÄ£¬×ܹ²»¨ÁËÒ»ÌìÒ»Ò¹µÄʱ¼ä£¬²é×ÊÁϺͿ´ÊÓƵÍê³ÉµÄ£¬µ«ÎÒ¶Ôµ¥Ðк¯ÊýºÍ¶àÐк¯ÊýûÓÐ×ö¹ý¶àµÄÑо¿£¬ÒòΪÕß¿ÉÒÔ²éÎĵµ¡£»¹ÓоÍÊǶà±í²éѯÑо¿Ò²±È½Ïdz£¬Õâ¿ÉÒÔÔÚÒÔºóÓõ½µÄʱºòÔÚ¾ßÌåÑо¿¡£ »¹ÓоÍÊÇÒªÊìϤÊý¾Ý¿âµÄ²Ù×÷£¬Ôöɾ¸Ä²é£¬ÕâЩ¶¼ÒªÏ൱ÊìÁ·£¬Íü¼ÇʱҪ¼°Ê±¿´±Ê¼Ç¡£
SQL
1....... ......