Á¬½Ó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
Ïà¹ØÎĵµ£º
1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......
import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
public static void main(String[] args)throws Exception {
Connection conn=null;
//====Á¬½ÓACCESSÊý¾Ý¿â ......
Èç¹ûÄã¾³£Óöµ½ÏÂÃæµÄÎÊÌ⣬Äã¾ÍÒª¿¼ÂÇʹÓÃSQL ServerµÄÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾äÁË£º
SQL³õѧÕß¡£
¾³£Íü¼Ç³£ÓõÄDML»òÊÇDDL SQL Óï¾ä¡£
ÔÚ¶àÈË¿ª·¢Î¬»¤µÄSQLÖУ¬Ã¿¸öÈ˶¼ÓÐ×Ô¼ºµÄSQLÏ°¹ß£¬Ã»ÓÐÒ»Ì×ͳһµÄ¹æ·¶¡£
ÔÚSQL Server Management StudioÖУ¬ÒѾ¸ø´ó¼ÒÌṩÁ˺ܶೣÓõÄÏÖ³ÉSQL¹æ·¶Ä£°å¡£
SQL Server Management ......
select * from student where name=?;
Èç¹û²»Óõ¥ÒýºÅÒýÆðÀ´£¬ pstmt.setString(1,"xx or 1=1");¼´sqlÓ¦¸Ã¾ÍÊÇselect * from student where name=xx or 1=1¾Í¿ÉÒÔÈ«²¿²é³ö¡£
Ç¿ÖƵ¥ÒýºÅÒýÆðÀ´£¬select * from student where name='xx or 1=1'¡£¾ÍÎÞЧÁË¡£
ÊýÖµÐ͵ÄûÓÐÒªÇóÓõ¥ÒýºÅÒýÆðÀ´£¬Ó¦¸ÃÊÇÓÉÓÚÓÐÒ»¸öת»»¹ý ......
SQL Server Filtered Indexes - What They Are, How to Use and Performance Advantages
Written By: Arshad Ali -- 7/2/2009 -
Problem
SQL Server 2008 introduces Filtered Indexes which is an index with a WHERE clause. Doesn’t it sound awesome especially for a table that has huge amount of data and ......