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

aspÔ¶³Ì·ÃÎÊsql serverÊý¾Ý¿â


<%
set conn=server.createobject("adodb.connection")
conn.connectionstring="PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=210.76.209.130;DATABASE=databasename;UID=sa;PWD=password;"
conn.open
%>
ÆäÖÐ 210.76.209.130 ¾ÍÊÇÔ¶³Ì·þÎñÆ÷µÄIP
¶þ¡¢ÎÒÓÃVBдÁ˸ö¹ÜÀíÈí¼þ,²¢²ÉÈ¡PINGÔ¶³Ì·þÎñÆ÷ÓòÃûµÄ·½·¨»ñȡԶ³Ì·þÎñÆ÷µÄIP,·þÎñÆ÷¶ËʹÓÃÁË»¨Éú¿ÇÈí¼þ,µ«ÎÞÂÛÔõôÑù¶¼ÊÇÊý¾Ý¿âÎÞ·¨·ÃÎʵÄÌáʾ,»¹ÓÐÎÒÔÚ³ÌÐòÀïµ÷ÓÃÁËPING³öµÄ·þÎñÆ÷IP,Ææ¹ÖµÄÊÇÈç¹ûÎÒ±¾µØSQL·þÎñÆô¶¯,³ÌÐò²»Ìáʾ³ö´í,ËäÈ»PING³öµÄIP²¢²»ÊÇÎÒ±¾»úµÄ,È´¿ÉÒÔÁ¬µ½ÎÒ±¾µØµÄSQLÊý¾Ý¿â,Èç¹ûÎҰѱ¾µØSQL·þÎñ¹Ø±Õ,¾ÍÄĸöÒ²Áª²»ÉÏÁË,ÇëÓо­ÑéµÄÅóÓѰï°ïÎÒ,¸æËßÎÒÔõô¿ÉÒÔʵÏ־ͿÉÒÔ.
£ººÃÏñÃâ·ÑµÄ¶þ¼¶ÓòÃû²»ÔÚÏßµÄʱºò½âÎö³öÀ´µÄÊDZ¾»úip127.0.0.1°É£¬Äã¿ÉÒÔÊÔÊÔÓýðÍòάµÄgnHost»òÕßÌìÁªÊÔÊÔ
Èý¡¢ÎҵIJÙ×÷ϵͳÊÇwin2003°²×°sqlserverÒÔºó,
ÔÚÔ¶³Ì»úµ÷ÓøûúÉϵÄÊý¾Ý¿â,ÿ´Î¶¼µÃÏÈÔÚ¿ªÊ¼ÔËÐÐÀïÊäÈë
\\192.168.1.18(ÎÒÕą̂»úÆ÷µÄIP)
È»ºóÊäÈëÓû§ÃûÃÜÂë²ÅÄÜÔÚ¿Í»§¶ËµÄ²éѯ·ÖÎöÆ÷Àï´ò¿ªsql server,
ÔÚÍøÉÏÕÒÁËÏÂ×ÊÁÏ˵ÊÇ×¢²á±íÀïµÄloginmodeÉèΪ2¾ÍÐÐÁË,¿ÉÊÇÎÒŪÁË»¹ÊDz»ÐÐ,
ÎÒʵÔÚŪ²»¶®ÁË,ËùÒÔÇë¸÷λ´óÏÀ°ïæ
£ºÒ»¶¨ÒªÏÈ·ÃÎʶԷ½»úÆ÷,
»òÕßÄã¿ÉÒÔ°ÑÄãµÄÓû§ÃûºÍÃÜÂë¼ÓÈë¶Ô·½»úÆ÷ÖÐÈ¥»ò°ÑÄãµÄguestÕʺŴò¿ª,ÕâÑù¶Ô·½·ÃÎÊÄã¾Í²»ÐèÒªÏÈ·ÃÎÊÄãµÄ»úÆ÷ÁË.
¼ÓÈëÆóÒµ¹ÜÀíÆ÷ ҲûÓÐÓÃ,Ò»¶¨Òª·ÃÎʶԷ½»úÆ÷.
net use \\192.168.0.1\ipc$ /user:Óû§Ãû ÃÜÂë Õâ¸ö¿ÉÒÔдΪһ¸ö.bat ¼ÓÈëÆô¶¯ÏîÀïÃæ.ÕâÑùÿ´Î¾Í²»Ó÷ÃÎʶԷ½»úÆ÷ÁË
ËÄ¡¢ÊÇÕâÑùµÄ£¬¼ÙÉèÎÒÓÐһ̨Óй«ÍøIP£¨Ïñ210.52.2.152ÕâÑùµÄIP£¬Ò²¾ÍÊÇÔÚÄÄÒ²¿ÉÒÔ·ÃÎʵķþÎñÆ÷£©£¬×°ÉÏSQLSERVER2000ºó¡£ÎÒÊÇ·ñ¿ÉÒÔÏñÔÚ¾ÖÓòÍøÄÚ·ÃÎÊ192.168.0.1Ò»Ñù·ÃÎÊ210.52.2.152ÄØ£¿
лл´ó¼Ò…£¡
---------------------------------------------------------------
¿ÉÒÔ£¬Èç¹û210.52.2.152ÊÇÕæIPµÄ»°£¬
²»¹ý£¬ÄãÒªÔÚ210.52.2.152½«SQL ServerµÄĬÈ϶˿Ú1433ÕÒ¿ª£¡£¡
¿ÉÒÔ¹©ÍâÍøÊ¹ÓÃ
ÎÒÔ­À´ÔÚ¿Í»§ÄÇÀï×öµÄÈí¼þ£¬¾ÍÊÇÔÚÔ¶³Ìͨ¹ý²¦ºÅ·ÃÎÊ×ܲ¿µÄSQL SERVERÊý¾Ý¿â£¬ËÙ¶È»¹ÐÐ


Ïà¹ØÎĵµ£º

ÓÃÓÚ·ÖÒ³ÏÔʾµÄSQLÎÄ

Ô­Ö· http://technet.microsoft.com/ja-jp/library/cc411406.aspx
 
¿´ÁËһƪSQL2005¹ØÓÚTransact-SQLµÄÇ¿»¯¼¼ÄܵĽéÉÜ£¬¾õµÃºÜÓÐÓô¦£¬¼òµ¥×ܽáÁËһϡ£
 
£¨Ò»£©Êý¾Ý¿â×ö³É
USE tempdb – »òÕßн¨Ò»¸öDB
CREATE TABLE SpeakerStats
(
  speaker      &n ......

´æ´¢¹ý³ÌÖÐSql Óï¾ä²éѯËÙ¶ÈÓÅ»¯ ijÀý

֮ǰµÄSQLÓï¾äÈçÏ£¬²éѯºÜÂý£¬6·ÖÖӶ඼ûÓнá¹ûÏÔʾ£¬Ò»¿ªÊ¼ÎÒÒÔΪÊÇ6ÕűíÁªºÏ²éѯ´øÀ´µÄËÙ¶ÈÂýµÄÎÊÌâ¡£
ºóÀ´·¢ÏÖÒòΪPO_D.ORDNOÓëPO_H.ORDNOÏàͬ£¬°ÑÂÌÉ«²¿·ÖÌæ»»Îª×ÏÉ«µÄ²¿·Ö£¬
°ÑPO_DÌæ»»ÎªPO_H£¬10ÃëÖÓ¾ÍÄܲéѯ³öÀ´
PS:PO_DÖÐ101401±ÊÊý¾Ý£¬PO_HÖÐ51341±ÊÊý¾Ý¡£
ËäûÓÐÏëÃ÷°×Ìæ»»Ö®ºóÌáËÙµ½Èç´ËÖ®¿ì½ö10Ã룬Óë6·Ö ......

Sql ²éѯ¼¼ÇÉ ÓÅÏÈÊä³öij½á¹û

SELECT EMP_ID,EMP_NO,LOGIN_NAME,EMP_NAME,SITE_CODE,DEPT_CODE,
JOB_DESC,HRMS_DEPT_CODE,MAIL_ACCOUNT,EXT_NO ,
(case when SITE_CODE='QCS' then 1 else 2 end) site
from dbo.AM_EMPLOYEE
WHERE ACTIVE = 'Y' AND EXT_NO = '6006'
order by site
ÏëÒªÔÚÔ±¹¤±íÖвé³öµç»°ºÅΪ6006µÄÔ±¹¤µÄÓ¢ÎÄÃûÀ´×÷ÎªÏµÍ³Ò³ÃæÉ ......

aspÊý¾Ý¿â²Ù×÷

ASPÁ¬½ÓÊý¾Ý¿â
¡¡¡¡ASPÁ¬½Ó11ÖÖÊý¾Ý¿âÓï·¨×ܽá
¡¡¡¡¾­³£Ê¹Óõ½ÓйØÊý¾Ý¿âµÄ²Ù×÷¡£°üÀ¨Á¬½Ó´úÂë¡¢SQLÃüÁîµÈµÈ£¬ÓÖ²»Ôø¿ÌÒâÈ¥¼ÇÒäËüÃÇ£¨ÎÒ±¾ÈËÊDz»Ô¸ÒâÈ¥¼ÇÕâ¶«¶«£©£¬ËùÒÔ³£³£ÔÚÓõ½µÄʱºòÓÖÈ¥²éÊé±¾£¬·­À´·­È¥¡£Ò»Ð©±È½ÏÉÙÓõÄÊý¾Ý¿â»¹²»Ò»¶¨ÄÜ˳ÀûÕÒµ½£¬ËùÒÔÏÖÔÚ°ÑËüÃÇÈ«¹éÄɵ½ÕâÀÌṩ´ó¼Ò²Î¿¼¡£
¡¡¡¡<Ò»>Êý¾Ý ......

asp»ñÈ¡URLµÄ·½·¨

·½·¨Ò»£º¼òµ¥£¬µÃ²»µ½²ÎÊý£¬Ö»ÓÐÒ»¸öÐéÄâ·¾¶
GetUrl =request("url")
ÀýÈ磺http://127.0.0.1/shiyan.asp?dfsdfsf=dsfsdfd&aa=dddd
»ñȡΪ:shiyan.asp
·½·¨¶þ£ºµÃµ½Õû¸öURL£¬µÃµ½²ÎÊý
'µÃµ½µ±Ç°Ò³ÃæµÄµØÖ·    
Function   GetUrl()    
On   Er ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ