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 ·þÎñĬÈ϶˿ڵÄÉèÖÃ
Ò»°ã¶øÑÔ,Î
Ïà¹ØÎĵµ£º
[code]declare @startdt datetime
declare @enddt datetime
select @startdt='2009-12-03',@enddt='2009-12-05'
select * from tb
where ¿ªÊ¼ÈÕÆÚ between @startdt and @enddt
or ½áÊøÈÕÆÚ between @startdt and @enddt
or @startdt between ¿ªÊ¼ÈÕÆÚ and ½áÊøÈÕÆÚ
or @enddt between ¿ªÊ¼ÈÕÆÚ and ......
Óï¾ä£ºselect rank() over(Order By ±íµÄÖ÷¼ü Desc) As UID ,ÆäËûÁÐ from ±í
˵Ã÷£ºrankº¯Êý
×÷Óãº
·µ»ØÖ¸¶¨Ôª×éÔÚÖ¸¶¨¼¯ÖеÄÅÅÃû£¨ÅÅÃû´Ó 1 ¿ªÊ¼£©
Rank(Tuple_Expression, Set_Expression [ ,Numeric Expression ] )
²ÎÊý£º
Tuple_Expression
Ò»¸öÓÐЧµÄ¶àά±í´ïʽ (MDX) Ôª ......
declare @dfname varchar(50)
select @dfname=a.name
from sysobjects a
inner join syscomments b on a.id=b.id
inner join sysconstraints  ......
ÔÚ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*/
±íÃ÷¶ÔÓï¾ä¿ ......
Ëæ×ÅB/SģʽӦÓÿª·¢µÄ·¢Õ¹£¬Ê¹ÓÃÕâÖÖģʽ±àдӦÓóÌÐòµÄ³ÌÐòÔ±Ò²Ô½À´Ô½¶à¡£µ«ÊÇÓÉÓÚ³ÌÐòÔ±µÄˮƽ¼°¾ÑéÒ²²Î²î²»Æë£¬Ï൱´óÒ»²¿·Ö³ÌÐòÔ±ÔÚ±àд´úÂëµÄʱºò£¬Ã»ÓжÔÓû§ÊäÈëÊý¾ÝµÄºÏ·¨ÐÔ½øÐÐÅжϣ¬Ê¹Ó¦ÓóÌÐò´æÔÚ°²È«Òþ»¼¡£Óû§¿ÉÒÔÌá½»Ò»¶ÎÊý¾Ý¿â²éѯ´úÂ룬¸ù¾Ý³ÌÐò·µ»ØµÄ½á¹û£¬»ñµÃijЩËûÏëµÃÖªµÄÊý¾Ý£¬Õâ¾ÍÊÇËùνµÄSQL Inj ......