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

Á¬½Ó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


Ïà¹ØÎĵµ£º

½â¾öSQL ServerתACCESS×Ô¶¯±àºÅÎÊÌâ


1.´ò¿ªSQL server enterprise mananger “ÆóÒµ¹ÜÀíÆ÷”
ÔÚÄãÒªµ¼³öµÄSQLÊý¾Ý¿âÉÏÊó±êÓÒ¼ü²Ëµ¥£ºËùÓÐÈÎÎñ-¡·µ¼³öÊý¾Ý
2.»Ø³öÏÖÒ»¸öµ¼³öÏòµ¼´°¿Ú¡£
Ñ¡Ôñ±»µ¼³öµÄÊý¾ÝÔ´£¬ÎªÄã¸Õ²ÅËùÑ¡ÔñµÄÊý¾Ý¿â£¬Èç¹û·¢ÏÖ²»¶ÔÓ¦×ÔÐÐÐ޸ġ£
3.½øÈëµ¼³öµ½Ä¿±êÊý¾ÝÔ´µÄÑ¡Ôñ£¬ÕâÀïÎÒÃÇҪת³ÉACCESSµÄÊý¾Ý¿â¡£×¢ÒâÑ¡ÔñÊý¾ÝÔ´ÀàÐÍÎ ......

JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,Oracle

import java.sql.*;
/*
* JAVAÁ¬½ÓACCESS£¬SQL Server,MySQL,OracleÊý¾Ý¿â
*
* */
public class JDBC {
  
public static void main(String[] args)throws Exception {
  
   Connection conn=null;
  
       //====Á¬½ÓACCESSÊý¾Ý¿â ......

ʹÓÃSQLServerÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾ä

Èç¹ûÄã¾­³£Óöµ½ÏÂÃæµÄÎÊÌ⣬Äã¾ÍÒª¿¼ÂÇʹÓÃSQL ServerµÄÄ£°åÀ´Ð´¹æ·¶µÄSQLÓï¾äÁË£º
SQL³õѧÕß¡£
¾­³£Íü¼Ç³£ÓõÄDML»òÊÇDDL SQL Óï¾ä¡£
ÔÚ¶àÈË¿ª·¢Î¬»¤µÄSQLÖУ¬Ã¿¸öÈ˶¼ÓÐ×Ô¼ºµÄSQLÏ°¹ß£¬Ã»ÓÐÒ»Ì×ͳһµÄ¹æ·¶¡£
ÔÚSQL Server Management StudioÖУ¬ÒѾ­¸ø´ó¼ÒÌṩÁ˺ܶೣÓõÄÏÖ³ÉSQL¹æ·¶Ä£°å¡£
SQL Server Management ......

Ϊʲôsql ÀïÒªÇóstring×Ö¶ÎÓõ¥ÒýºÅÒýÆðÀ´

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 Server2008 Filtered Indexes

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ