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

SQL ServerÁ¬½ÓÖеÄËĸö×î³£¼û´íÎó

SQL ServerÁ¬½ÓÖеÄËĸö×î³£¼û´íÎó:
Ò»."SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø"
Õâ¸öÊÇ×ÔÓµÄ,´íÎó·¢ÉúµÄÔ­Òò±È½Ï¶à,ÐèÒª¼ì²éµÄ·½ÃæÒ²±È½Ï¶à.
Ò»°ã˵À´,ÓÐÒÔϼ¸ÖÖ¿ÉÄÜÐÔ:
1,SQL ServerÃû³Æ»òIPµØַƴдÓÐÎó
2,·þÎñÆ÷¶ËÍøÂçÅäÖÃÓÐÎó
3,¿Í»§¶ËÍøÂçÅäÖÃÓÐÎó
Òª½â¾öÕâ¸öÎÊÌâ,ÎÒÃÇÒ»°ãÒª×ñÑ­ÒÔϵIJ½ÖèÀ´Ò»²½²½ÕÒ³öµ¼Ö´íÎóµÄÔ­Òò.
============= Ê×ÏÈ,¼ì²éÍøÂçÎïÀíÁ¬½Ó =============
ping <·þÎñÆ÷IPµØÖ·/·þÎñÆ÷Ãû³Æ>
Èç¹û ping <·þÎñÆ÷IPµØÖ·> ²»³É¹¦,˵Ã÷ÎïÀíÁ¬½ÓÓÐÎÊÌâ,ÕâʱºòÒª¼ì²éÓ²¼þÉ豸,ÈçÍø¿¨,HUB,·ÓÉÆ÷µÈ.
»¹ÓÐÒ»ÖÖ¿ÉÄÜÊÇÓÉÓÚ¿Í»§¶ËºÍ·þÎñÆ÷Ö®¼ä°²×°ÓзÀ»ðǽÈí¼þÔì³ÉµÄ,±ÈÈç ISA Server.·À»ðǽÈí¼þ¿ÉÄÜ»áÆÁ±Î¶Ô ping,telnet µÈµÄÏìÓ¦
Òò´ËÔÚ¼ì²éÁ¬½ÓÎÊÌâµÄʱºò,ÎÒÃÇÒªÏÈ°Ñ·À»ðǽÈí¼þÔÝʱ¹Ø±Õ,»òÕß´ò¿ªËùÓб»·â±ÕµÄ¶Ë¿Ú.
Èç¹ûping <·þÎñÆ÷IPµØÖ·> ³É¹¦¶ø,ping <·þÎñÆ÷Ãû³Æ> ʧ°Ü
Ôò˵Ã÷Ãû×Ö½âÎöÓÐÎÊÌâ,ÕâʱºòÒª¼ì²é DNS ·þÎñÊÇ·ñÕý³£.
ÓÐʱºò¿Í»§¶ËºÍ·þÎñÆ÷²»ÔÚͬһ¸ö¾ÖÓòÍøÀïÃæ,ÕâʱºòºÜ¿ÉÄÜÎÞ·¨Ö±½ÓʹÓ÷þÎñÆ÷Ãû³ÆÀ´±êʶ¸Ã·þÎñÆ÷,ÕâʱºòÎÒÃÇ¿ÉÒÔʹÓÃHOSTSÎļþÀ´½øÐÐÃû×Ö½âÎö,
¾ßÌåµÄ·½·¨ÊÇ:
1.ʹÓüÇʱ¾´ò¿ªHOSTSÎļþ£¨Ò»°ãÇé¿öÏÂλÓÚC:\WINNT\system32\drivers\etc£©.
Ìí¼ÓÒ»ÌõIPµØÖ·Óë·þÎñÆ÷Ãû³ÆµÄ¶ÔÓ¦¼Ç¼,Èç:
172.168.10.24 myserver
2.»òÔÚ SQL Server µÄ¿Í»§¶ËÍøÂçʵÓù¤¾ßÀïÃæ½øÐÐÅäÖÃ,ºóÃæ»áÓÐÏêϸ˵Ã÷.
============= Æä´Î,ʹÓà telnet ÃüÁî¼ì²éSQL Server·þÎñÆ÷¹¤×÷״̬ =============
telnet <·þÎñÆ÷IPµØÖ·> 1433
Èç¹ûÃüÁîÖ´Ðгɹ¦,¿ÉÒÔ¿´µ½ÆÁĻһÉÁÖ®ºó¹â±êÔÚ×óÉϽDz»Í£ÉÁ¶¯,Õâ˵Ã÷ SQL Server ·þÎñÆ÷¹¤×÷Õý³£,²¢ÇÒÕýÔÚ¼àÌý1433¶Ë¿ÚµÄ TCP/IP Á¬½Ó
Èç¹ûÃüÁî·µ»Ø"ÎÞ·¨´ò¿ªÁ¬½Ó"µÄ´íÎóÐÅÏ¢,Ôò˵Ã÷·þÎñÆ÷¶ËûÓÐÆô¶¯ SQL Server ·þÎñ,
Ò²¿ÉÄÜ·þÎñÆ÷¶ËûÆôÓà TCP/IP ЭÒé,»òÕß·þÎñÆ÷¶ËûÓÐÔÚ SQL Server ĬÈϵĶ˿Ú1433ÉϼàÌý.
=============½Ó×Å,ÎÒÃÇÒªµ½·þÎñÆ÷Éϼì²é·þÎñÆ÷¶ËµÄÍøÂçÅäÖÃ,¼ì²éÊÇ·ñÆôÓÃÁËÃüÃû¹ÜµÀ.ÊÇ·ñÆôÓÃÁË TCP/IP ЭÒéµÈµÈ =============
¿ÉÒÔÀûÓà SQL Server ×Ô´øµÄ·þÎñÆ÷ÍøÂçʹÓù¤¾ßÀ´½øÐмì²é.
µã»÷:³ÌÐò -- Microsoft SQL Server -- ·þÎñÆ÷ÍøÂçʹÓù¤¾ß
´ò¿ª¸Ã¹¤¾ßºó,ÔÚ"³£¹æ"ÖпÉÒÔ¿´µ½·þÎñÆ÷ÆôÓÃÁËÄÄЩЭÒé.
Ò»°ã¶øÑÔ,ÎÒÃÇÆôÓÃÃüÃû¹ÜµÀÒÔ¼° TCP/IP ЭÒé.
µãÖÐ TCP/IP ЭÒé,Ñ¡Ôñ"ÊôÐÔ",ÎÒÃÇ¿ÉÒÔÀ´¼ì²é SQK Server ·þÎñĬÈ϶˿ڵÄÉèÖÃ
Ò»°ã¶øÑÔ,Î


Ïà¹ØÎĵµ£º

SQL ·À×¢Èëʽ¹¥»÷

1¡¢¼ì²éÊÇ·ñÓзǷ¨×Ö·û
public static boolean sql_inj(String str)
{
    String inj_str = "'|and|exec|insert|select|delete|update|
count|*|%|chr|mid|master|truncate|char|declare|;|or|-|+|,";
//ÕâÀïµÄ¶«Î÷»¹¿ÉÒÔ×Ô¼ºÌí¼Ó
String[] inj_stra=inj_str.split("\\|");
    for ......

asp.net(c#) ÏÂSQL´æ´¢¹ý³ÌʹÓÃÏêϸʵÀý

¼ÇÈ¡¼Ç¼¼¯
create procedure getArticle
as
select * from Article_Content
GO
asp.net µ÷Ó÷½·¨
  SqlConnection Conn = new SqlConnection();
        Conn.ConnectionString = Data.Connstr();
        Conn.Open();
  ......

SQLÎÞÏÞ·Ö¼¶½á¹¹

×î½ü£¬ÒòΪÏîÄ¿µÄÔ­Òò£¬ÐèÒªÉè¼ÆÒ»¸öÊý¾Ý¿â£¬¸ÃÊý¾Ý¿âµÄ¹¦ÄÜÖ÷ÒªÊÇÃèÊöÎļþϵͳµÄ½á¹¹ºÍÎļþÐÅÏ¢£¬ÔÚÍøÉÏÕÒÁ˺ܶàµÄ×ÊÁÏ£¬µ«ÊÇÐí¶àÉè¼ÆҪôÕë¶Ô²éѯÁ¿±È½Ï¶àµÄÀ´×ö£¬ÒªÃ´Õë¶ÔÐ޸ġ¢²åÈëÁ¿±È½Ï¶àµÄÀ´×ö£¬¶ø¶ÔÓÚÎļþϵͳ¶øÑÔ£¬ËüµÄ²éѯ¡¢²åÈë¡¢Ð޸Ķ¼ÊÇÏ൱Ƶ·±µÄ£¬Òò´Ë£¬Êý¾Ý¿âµÄÉè¼Æ¼«ÆäÖØÒª,ÏÖ½«×Ô¼ºµÄÒ»µãÏ뷨˵˵£¬Ï£Íû´ ......

SQLɾ³ýÓÐĬÈÏÖµ×ֶΣ¨×ª£©

declare   @dfname   varchar(50)  
select   @dfname=a.name  
from   sysobjects   a
inner join   syscomments   b   on   a.id=b.id  
inner join   sysconstraints  ......

SQLÓï¾äÓÅ»¯·½·¨30Àý

ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ­³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle
HINTµÄÓ÷¨£º
1. /*+ALL_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO='SCOTT'; 2. /*+FIRST_ROWS*/
±íÃ÷¶ÔÓï¾ä¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ