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

¸ü¸ÄSQL ServerĬÈϵÄ1433¶Ë¿Ú

1.SqlServer·þÎñʹÓÃÁ½¸ö¶Ë¿Ú£ºTCP-1433¡¢UDP-1434¡£ÆäÖÐ1433ÓÃÓÚ¹©SqlServer¶ÔÍâÌṩ·þÎñ£¬1434ÓÃÓÚÏòÇëÇóÕß·µ»ØSqlServerʹÓÃÁËÄǸöTCP/IP¶Ë¿Ú¡£
¿ÉÒÔʹÓÃSQL ServerµÄÆóÒµ¹ÜÀíÆ÷¸ü¸ÄSqlServerµÄĬÈÏTCP¶Ë¿Ú¡£·½·¨ÈçÏ£º
a¡¢´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬ÒÀ´ÎÑ¡Ôñ×ó²à¹¤¾ßÀ¸µÄ“Microsoft SQL Servers - SQL Server×锣¬´ò¿ª“SQLʵÀý”£¨Êµ¼Ê»·¾³ÖÐΪҪÐ޸ĵÄSQL Server·þÎñÆ÷Ãû³Æ£©µÄÊôÐÔ¶Ô»°¿ò£¬µã»÷“³£¹æ”Ñ¡ÏµÄ×îÏ·½µÄ“ÍøÂçÅäÖã¨N£©”°´Å¥£¬¾Í¿ÉÒÔ´ò¿ª“SQL Server ÍøÂçʹÓù¤¾ß”¶Ô»°¿ò¡£
b¡¢ÔÚ“ÆôÓõÄЭÒé”ÁбíÀïÓÐTCP/IPЭÒ飬ÔÚÊôÐÔÀïµÄĬÈ϶˿ÚÑ¡ÏîÖÐÊäÈëÒªÐ޸ĵĶ˿ںż´¿ÉÐ޸ġ£»¹ÓÐÒ»ÏîΪÒþ²Ø·þÎñÆ÷£¬Èç¹ûÑ¡ÖÐÔò±íʾ×ſͻ§¶ËÎÞ·¨Í¨¹ýö¾Ù·þÎñÆ÷À´¿´µ½Õą̂·þÎñÆ÷£¬Æðµ½±£»¤µÄ×÷Ó㬶øÇÒ²»Ó°ÏìÁ¬½Ó¡£
2.SqlAgent·þÎñʹÓÃTCP-1625¡¢TCP-1640¶Ë¿ÚÌṩ·þÎñ¡£
3.SQL ²éѯ·ÖÎöÆ÷£¬Í¨¹ý1601¶Ë¿Ú·ÃÎÊ1433£¬Á¬½ÓSqlServer 


Ïà¹ØÎĵµ£º

Delphi Excel to Sql Server

 unit Unit1;
interface
uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExtCtrls, Grids, DBGrids, DB, ADODB,comobj, OleServer,
  ExcelXP;
type
  TForm1 = class(TForm)
    ADOConn: TADOConnection;
& ......

sql server 2005°²×°¹ý³ÌÖÐÓöµ½µÄһЩÎÊÌâ

°²×°µÄ×é¼þºÍ°æ±¾µÄÐÅÏ¢
Microsoft SQL Server Management Studio      9.00.1399.00
Microsoft Analysis Services ¿Í»§¶Ë¹¤¾ß      2005.090.1399.00
Microsoft Êý¾Ý·ÃÎÊ×é¼þ (MDAC)      6.1.7600.16385 (win7_rtm.090713 ......

¹ØÓÚÓÃADO.NET »ñÈ¡ SQL SERVER ±í SCHEMAµÄһЩ¼Ç¼

×îÏÈÏ£ÍûʹÓÃdatatable.columnsÖÖËùº¬ÓеÄÊôÐÔÖ±½Ó»ñÈ¡Ïà¹ØÐÅÏ¢£¬¿É²âÊÔºó·¢ÏÖ£¬³ýÁË×Ö¶ÎÃûºÍ×Ö¶ÎÀàÐÍ£¬ÆäËûÊý¾ÝÒ»¸ÅÕÒ²»µ½¡£
GOOGLEÍøÉϺܶàÖÖ·½·¨£¬ÆäÖÐ×îÖ±½ÓµÄÊÇÖ±½Ó²éѯSQLSERVERµÄinformation_schema.columsÊÓͼ£¬´ÓÖÐÖ±½Ó»ñÈ¡ÐÅÏ¢£¬²»¹ýºóÀ´ÓÖ·¢ÏÖ£¬ËäÈ»Êý¾ÝʱȫÁË£¬¿ÉÊÇÐèҪͨ¹ýºÜ¸´Ôӵķ½·¨£¨sys.all_columns sys ......

eclipse ¹ØÁª sql server µÄJDBCÎÊÌâ

eclipse ¹ØÁª sql server µÄJDBCÎÊÌâ
±à³ÌÔËÐкóÌáʾ£º
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
ÉÏÍø²éÁË£¬ÓеÄ˵ÔÚ»·¾³±äÁ¿ÀïµÄclasspathÌí¼Ó JDBCÀïµÄ3¸öjarÎļþ¾Í¿ÉÒÔ£¬µ«ÊÇʹÓúó»¹ÊDz»ÐС£
ºóÀ´²ÅÖªµÀ½â¾ö·½·¨£º
°ü×ÊÔ´¹ÜÀíÆ÷-->°üÃûÓÒ¼ü"¹¹½¨Â·¾¶"--> ......

oralce sqlÓÅ»¯34Ìõ

ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLE µÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ