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

²»ÄÜÁ¬½Ó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


Ïà¹ØÎĵµ£º

SQL Ìõ¼þÓï¾ä

µÚÒ»ÖÖ£º
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 ......

SQLÖ®11 Êý¾Ý¿âÉè¼Æ

º¯ÊýÒÀÀµ
==========================================
Ò»¡¢º¯ÊýÒÀÀµ¸ÅÄî  
    
  ¡¡¡¡º¯ÊýÒÀÀµÊÇ´ÓÊýѧ½Ç¶ÈÀ´¶¨ÒåµÄ£¬ÔÚ¹ØϵÖÐÓÃÀ´¿Ì»­¹Øϵ¸÷ÊôÐÔÖ®¼äÏ໥ÖÆÔ¼¶øÓÖÏ໥ÒÀÀµµÄÇé¿ö¡£º¯ÊýÒÀÀµÆÕ±é´æÔÚÓÚÏÖʵÉú»îÖУ¬±ÈÈ磬ÃèÊöÒ»¸öѧÉúµÄ¹Øϵ£¬¿ÉÒÔÓÐѧºÅ¡¢ÐÕÃû¡¢ËùÔÚϵµÈ¶à¸öÊôÐÔ£ ......

C#ÖÐÓÃÓÚÁ¬½ÓSQLÊý¾Ý¿âµÄSQLHelperÀà

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;   //ÒýÓÃÃüÃû¿Õ¼ä
namespace DAL
{
    /*******************************************************************************
  &n ......

SQL¸ß¼¶Ê¹ÓÃÊý¾Ý¿â

SQL¸ß¼¶Ê¹ÓÃ
SELECT¸ß¼¶²éѯ
´íÎó´¦Àí
ÊÂÎñ´¦Àí
Êý¾ÝµÄËø¶¨
Óαê
1.SELECT¸ß¼¶²éѯ
Ç°ÃæÒѾ­½éÉÜÁËSELECTÓï¾äµÄÓ÷¨£¬±¾½ÚÖ÷Òª½éÉÜÊý¾Ý»ã×Ü¡¢Áª½Ó²éѯ¡¢×Ó²éѯºÍ¹Ø¼ü´ÊUNIONµÄʹÓá£
(1)Êý¾Ý»ã×Ü
Ϊ¾ö²ßÖ§³ÖϵͳÉú³É¾ÛºÏÊÂÎñµÄ»ã×ܱ¨±íÊÇÒ»ÏÔÓ²¢ÇÒÏ൱ÏûºÄ×ÊÔ´µÄ¹¤×÷¡£SQL Server 2000ÌṩÁ½¸öÁé»îÇÒÇ¿´óµÄ×é¼þ ......

¹ØÓÚ·ÖÒ³µÄsqlÓï¾ä

¶ÔÓÚÓÐÖ÷¼ü×Ô¶¯Ôö³¤Êý¾Ý¿â±í£¬ÔÚ½øÐзÖÒ³ÉèÖÃʱ£¬ÎÒÈÏΪ»¹±È½Ï²»´íµÄÊÇ£º
SELECT TOP Ò³´óС *
from TestTable
WHERE (ID >
          (SELECT MAX(id)
         from (SELECT TOP Ò³´óС*Ò³Êý id
     ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ