Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ·þÎñĬÈ϶˿ڵÄÉèÖÃ
Ò»°ã¶øÑÔ,Î


Ïà¹ØÎĵµ£º

ʹÓÃVB½«Excelµ¼Èëµ½SqlÖÐ

ʹÓÃVB°ÑExcelµ¼Èëµ½SqlÊý¾Ý¿âÖУ¬ÆäʵÓм¸ÖÖ·½·¨¡£
ÏÂÃæÎÒ½éÉܵÄÕâÖÖ·½·¨£¬½ÏΪ¼òµ¥¡£
ÆäʵÕâÖÖ·½·¨µÄ»°£¬ÊÇÖ±½ÓʹÓÃT-SQL²Ù×÷µÄ£¬Òò´Ë£¬µ½ÁËVBÀïÃ棬ֱ½ÓeccuteÕâ¸ö´úÂë¾ÍOKÁ˵ġ£
-----------------------------------------------------ÏÂÃæÊÇÔÚT-sqlÖеÄÓï¾ä
if object_id('NewTable') is not null/*ÅжϱíNewTabl ......

EXCELÉú³ÉSQL½¨±í´æ´¢¹ý³ÌµÄVBA½Å±¾

HO~HO~EXCELÉú³ÉSQL½¨±í´æ´¢¹ý³ÌµÄVBA½Å±¾^_^ÔÞÒ»ÏÂ
2007-12-11 10:39
'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ È«¾Ö±äÁ¿¶¨Òå
Const MAX_COLUMN_NUM = 50
Dim stOutputPath As String
Dim stOutputFile As String
Dim stDBName As String
Dim stUserName As String
Dim stUserPasswd As ......

sql²éѯµÄÎÞÏÞ·ÖÀà²éѯµÄÉè¼Æ

×î½üÔÚÕÒÒ»´Îsql²éѯµÄÎÞÏÞ·ÖÀà²éѯµÄÉè¼Æ£¬ÍøÉÏÕÒÁËÒ»ÏÂÕâ¸öÊý¾Ý±íµÄÉè¼ÆºÜÓÐÌØÉ«£¬
²»Óõݹ飬ÒÀ¿¿¸ö¼òµ¥SQLÓï¾ä¾ÍÄÜÁгö²Ëµ¥£¬¿´¿´Õâ¸öÊý¾Ý±íÔõôÉè¼ÆµÄ£¬²¢¶ÔÏÂÃæµÄÊý¾Ý±í½á¹¹µÄ²éѯ½øÐзÖÎö.
Êý¾Ý¿â×ֶδó¸ÅÈçÏ£º
-----------------------------------------------------------------------------------
id  ......

sql c#

C-#ÈëÞ­µä(µÚÈý°æ).pdf
using System;
using System.Data;
using System.Data.SqlClient;
namespace My_Student
{
    static class Program
    {
       
        static void Main()
  &n ......

ÓÃVFP9.0ºÍSQL2000¹¹½¨C/S°æ±¾µÄÈËʹÜÀíϵͳ

±¾ÊµÀýÒ»Ì×ÈËʹÜÀíϵͳ£º¿ª·¢¹¤¾ßΪVFP9.0¡¢SQL2000¡¢EXCEL;ʹÓÃÁËAdobe PhotoshopƽÃæÉè¼ÆÈí¼þ£¬²ÉÓÃÁËSPT´©Í¸¼¼Êõ£¬µ÷ÓÃÁËAPIº¯Êý£¬ÊµÏÖÁ˶Ôϵͳʱ¼äµÄͳһ¿ØÖÆ¡¢¶ÔDNSµÄ´úÂë¿ØÖÆ¡¢¶ÔÓòÃû½âÎöµÄÓ¦Ó㬵ȵÈ
ÔΣ¬ÔõôÉÏ´«£¬£¨°üº¬Ô´Âëδ±àÒëµÄ£©ÏëÒªµÄ¸øÎÒ·¢E-MAIL:zhao@tom.com ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ