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

ÔõÑùÔ¶³Ì·ÃÎÊsqlserver 2005

ÎÒÏëÔÚÁíһ̨»úÆ÷ÉÏ·ÃÎʱ¾»úµÄsqlserver 2005 ¸ÃÔõôÅäÖá£Òª·ÃÎʵĻúÆ÷°²×°ÁËsqlserver 2005ÓõIJÙ×÷ϵͳÊÇwindows 2003 £¬Òª½øÐÐÔ¶³Ì·ÃÎʵĻúÆ÷Ò²°²×°ÁËsqlserver 2005 ÓõIJÙ×÷ϵͳÊÇwindows £Ø£Ð¡£¸ÃÔõôÅäÖòÅÄÜÈÃÁ½Ì¨»úÆ÷µÄÊý¾Ý¿â»¥Ïà·ÃÎÊ¡£ÏëÇë¸ßÊÖÖ¸µãһϡ£
ͨ¹ýipµØÖ·¾Í¿ÉÒÔ·ÃÎÊ¡£

ÊäÈëIP£¬Userid£¬password¾Í¿ÉÒÔÁË£¡~

Á½Ì¨µçÄÔÒªÁ¬Í¨£¬¿´ping ·þÎñÆ÷IPÄÜ·ñpingͨ¡£
¡°¿ªÊ¼->³ÌÐò->Microsoft SQL Server 2005->ÅäÖù¤¾ß->SQL Server ÍâΧӦÓÃÅäÖÃÆ÷¡±
ÔÚ¡°SQL Server 2005 ÍâΧӦÓÃÅäÖÃÆ÷¡±Ò³, µ¥»÷¡°·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷¡±
È»ºóµ¥»÷Õ¹¿ª¡°Êý¾Ý¿âÒýÇæ¡±£¬ Ñ¡ÖС°Ô¶³ÌÁ¬½Ó¡±£¬ÔÚÓÒ±ßÑ¡ÖС°±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó¡±£¬
ÔÙÑ¡ÔñҪʹÓõÄЭÒ飬( Õâ¸öµØ·½Ó¦µ±ÆôÓÃTCP/IP ºÍÃüÃû¹ÜµÀ·þÎñ£¡)µ¥»÷¡°Ó¦Óá±£¬
Õ¹¿ª¡°Êý¾Ý¿âÒýÇæ¡±£¬ Ñ¡ÖС°·þÎñ¡±£¬ÔÚÓұߵ¥»÷¡°Í£Ö¹¡±£¬µÈµ½ MSSQLSERVER ·þÎñÍ£Ö¹£¬
È»ºóµ¥»÷¡°Æô¶¯¡±£¬ÖØÐÂÆô¶¯MSSQLSERVER ·þÎñ¡£

http://topic.csdn.net/u/20090110/08/028e238a-e190-409e-b7d5-0d0c08b23df4.html

¿ªÆôSqlClient·þÎñ
ÉèÖ÷À»ðǽ

3¥˵µÄ¹»ÏêϸÁË¡£¡£

ͬÒâÉÏ

up

ºÍ·ÃÎʱ¾µØÒ»Ñù¡£·þÎñÆ÷Ãû£¬Êý¾Ý¿âÃû£¬Óû§Ãû£¬ÃÜÂë
·þÎñÆ÷Ãû¿ÉÒÔÊÇÔ¶³Ì·þÎñÆ÷µÄÃû×Ö»òÕßIP¡£
²»¹ýÔ¶³Ì·þÎñÆ÷Òª¿ªÍ¨Ô¶³Ì·ÃÎʵÄȨÏ޲ſÉÒÔ¡£

ÔÚA»úÌí¼ÓB»úµÄsqlÊý¾Ý¿â

ÒýÓÃ
ºÍ·ÃÎʱ¾µØÒ»Ñù¡£·þÎñÆ÷Ãû£¬Êý¾Ý¿âÃû£¬Óû§Ãû£¬ÃÜÂë
·þÎñÆ÷Ãû¿ÉÒÔÊÇÔ¶³Ì·þÎñÆ÷µÄÃû×Ö»òÕßIP¡£
²»¹ýÔ¶³Ì·þÎñÆ÷Òª¿ªÍ¨Ô¶³Ì·ÃÎʵÄȨÏ޲ſÉÒÔ¡£


Õâ¸öÕý½â



Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......

Çóc#²Ù×÷sqlserverÊý¾Ý¿âÎÊÌâ

ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......

sqlserver´íÎó - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......

sqlserver order byÅÅÐòÎÊÌâ - .NET¼¼Êõ / ASP.NET

Order by ʱ¼ä×Ö¶Î desc
 ÅŲ»ÁË˳ÐòÁË
ǰÌáÊÇÎÒÕâ¸öÊÇÒ»¸öÊÔͼ£¿
ËûÔÚÐÞ¸ÄÊÔͼÀïÃæËüÅÅÐòÁË£¡¿ÉÊǵÈÎÒ´ò¿ªÊÔͼ²é¿´µÄʱºòÊý¾Ý²¢Ã»ÓнøÐÐÅÅÐò£¡£¡ºÜÊÇÓôÃÆ£¡Ï£Íû¸÷Ϊ¸ßÊÖÖ¸µã£¡£¡
¼±¼±£¡£¡£¡£¡
ËûÔÚÐÞ¸ÄÊ ......

JDBCÁ¬½ÓSQLServer 2000µÄÎÊÌâ - Java / Web ¿ª·¢

HTTP Status 500 - 
--------------------------------------------------------------------------------
type Exception report
message 
description The server encountered an internal error ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ