²»ÄÜÁ¬½ÓSQL SERVER 2000 µÄ½â¾ö·½°¸
±¾ÎÄת×Ô£ºhttp://blog.csdn.net/java2000_net/archive/2008/04/05/2252640.aspx
±¾ÎÄÊÕ¼Á˲»ÄÜÁ¬½ÓSQL Server £¬±¨ The Network Adapter could not establish the connection Òì³£µÄËùÓÐÓöµ½¹ýµÄÔÒò£¬²¢ÌṩÁËͼÐλ¯µÄÅŲéÏòµ¼¡£
²»¹ý¸ù¾Ý¾Ñ飬ûÓÐÉý¼¶µ½SP4µÄ¿ÉÄÜÐÔ×î¸ß¡£¿ÉÒÔÖ±½Ó¿´µÚ6²¿·Ö¡£
³£¼ûµÄ´íÎóΪ£º The Network Adapter could not establish the connection
1 ¼ì²éSQL SERVER ÊÇ·ñÔÊÐíÔ¶³Ì·ÃÎÊ.
¾ßÌå²½Öè:
1)´ò¿ª"ÆóÒµ¹ÜÀíÆ÷",´ò¿ª¿ØÖÆ̨¸ùĿ¼>SQL Server ×é>Êý¾Ý¿â
2)ÔÚÏàÓ¦"Êý¾Ý¿â"Éϵ¥»÷ÓÒ¼ü,Ñ¡Ôñ"ÊôÐÔ"
3)Ñ¡Ôñ"Á¬½Ó"Ñ¡Ï,¼ì²é"Ô¶³Ì·þÎñÆ÷Á¬½Ó"ÏÂ,RPC·þÎñÊÇ·ñÑ¡Ôñ.
2 ʹÓÃtelnet IPµØÖ· 1433,ϵͳÊÇ·ñÌáʾÁ¬½Ó³ö´í
±ÈÈç telnet 127.0.0.1 1433
Èç¹û³öÏÖºÚÆÁ£¬Õâ¶Ë¿ÚÕý³£
ÈçϵͳÌáʾ³ö´í
¼ì²éÊÇ·ñ·À»ðǽÆÁ±ÎÁËSQL SERVER »ò java IDE µÄÍøÂç·ÃÎʶ˿Ú
Èç¹ûÊÇ,¹Ø±Õ·À»ðǽ,ÖØÐÂÆô¶¯SQL SERVERºÍjava IDE,½øÐвâÊÔ,
Èç¹ûϵͳÈÔÌáʾÉÏÊö´íÎó,³¢ÊÔÏÂÁв½Öè
3 ¼ì²éSQL SERVER ¶Ë¿ÚºÅ¼°ÊÇ·ñÆôÓÃÁËTCP/IPÐÒé
¾ßÌå²½Öè:
1)´ò¿ª"ÆóÒµ¹ÜÀíÆ÷",´ò¿ª¿ØÖÆ̨¸ùĿ¼>SQL Server ×é>Êý¾Ý¿â
2)ÔÚÏàÓ¦"Êý¾Ý¿â"Éϵ¥»÷ÓÒ¼ü,Ñ¡Ôñ"ÊôÐÔ"
3)Ñ¡Ôñ"³£¹æ"Ñ¡Ï,µã»÷"ÍøÂçÅäÖÃ",ÈçÆôÓõÄÐÒéÖÐÎÞ"TCP/IPÐÒé"½«Æä¼ÓÈë
4)Ñ¡Ôñ"TCP/IPÐÒé",µã»÷"ÊôÐÔ",¼ì²éÆä¶Ë¿ÚºÅÊÇ·ñΪ1433
5)Èç¶Ë¿ÚºÅΪ1433½«ÆäÐÞ¸ÄΪÆäËü¶Ë¿ÚºÅ,ÐÞ¸ÄjdbcÁ¬½ÓÓï¾ä,½«¶Ë¿ÚºÅͬÑù¸ÄΪÐÂÆôÓõĶ˿ںÅ,Èçjdbc:microsoft:sqlserver://server_name:1400(¼ÙÉèж˿ںÅΪ 1400)
4 ÒÔϵķ½·¨ÄãÿÖÖµÄÈ¥ÊÔÊÔ:
1)¼ì²éÒ»ÏÂsql serverµÄconnectionÓÐûÓÐfull.
2)Èç¹ûÊÇÈÏÖ¤µÄÎÊÌâ.
¿Éµ½sql enterprice manager->Ö¸¶¨server->ÄÚÈÝ->°²È«ÐÔ. °ÑÑéÖ¤¸ÄΪ SQL server ¼° windows.
3)µãÑ¡ÊôÐÔ¼ì²éÒ»ÏÂportÊÇ·ñÕýÈ·.
4)Ö´ÐÐ%MSSQL_HOME%\80\Tools\Binn\SVRNETCN.exe
°ÑTCP/IPÆôÓÃ.
5)¹Øµô·À»ðǽ.
6)°ÑSQL server updateµ½sp4:
http://www.microsoft
Ïà¹ØÎĵµ£º
µÚÒ»ÖÖ£º
SELECT
CASE
WHEN
price IS NULL THEN
'Not yet priced'
WHEN
price < 10 THEN
'Very Reasonable Title'
WHEN
price >= 10 AND
price < 20 THEN
'Coffee Table Title'
EL ......
º¯ÊýÒÀÀµ
==========================================
Ò»¡¢º¯ÊýÒÀÀµ¸ÅÄî
¡¡¡¡º¯ÊýÒÀÀµÊÇ´ÓÊýѧ½Ç¶ÈÀ´¶¨ÒåµÄ£¬ÔÚ¹ØϵÖÐÓÃÀ´¿Ì»¹Øϵ¸÷ÊôÐÔÖ®¼äÏ໥ÖÆÔ¼¶øÓÖÏ໥ÒÀÀµµÄÇé¿ö¡£º¯ÊýÒÀÀµÆÕ±é´æÔÚÓÚÏÖʵÉú»îÖУ¬±ÈÈ磬ÃèÊöÒ»¸öѧÉúµÄ¹Øϵ£¬¿ÉÒÔÓÐѧºÅ¡¢ÐÕÃû¡¢ËùÔÚϵµÈ¶à¸öÊôÐÔ£ ......
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient; //ÒýÓÃÃüÃû¿Õ¼ä
namespace DAL
{
/*******************************************************************************
&n ......
SQL¸ß¼¶Ê¹ÓÃ
SELECT¸ß¼¶²éѯ
´íÎó´¦Àí
ÊÂÎñ´¦Àí
Êý¾ÝµÄËø¶¨
Óαê
1.SELECT¸ß¼¶²éѯ
Ç°ÃæÒѾ½éÉÜÁËSELECTÓï¾äµÄÓ÷¨£¬±¾½ÚÖ÷Òª½éÉÜÊý¾Ý»ã×Ü¡¢Áª½Ó²éѯ¡¢×Ó²éѯºÍ¹Ø¼ü´ÊUNIONµÄʹÓá£
(1)Êý¾Ý»ã×Ü
Ϊ¾ö²ßÖ§³ÖϵͳÉú³É¾ÛºÏÊÂÎñµÄ»ã×ܱ¨±íÊÇÒ»ÏÔÓ²¢ÇÒÏ൱ÏûºÄ×ÊÔ´µÄ¹¤×÷¡£SQL Server 2000ÌṩÁ½¸öÁé»îÇÒÇ¿´óµÄ×é¼þ ......
¶ÔÓÚÓÐÖ÷¼ü×Ô¶¯Ôö³¤Êý¾Ý¿â±í£¬ÔÚ½øÐзÖÒ³ÉèÖÃʱ£¬ÎÒÈÏΪ»¹±È½Ï²»´íµÄÊÇ£º
SELECT TOP Ò³´óС *
from TestTable
WHERE (ID >
(SELECT MAX(id)
from (SELECT TOP Ò³´óС*Ò³Êý id
  ......