SQL SERVER2000´ò²¹¶¡ÎÊÌâ»ã×Ü
SQL SERVER2000´ò²¹¶¡ÎÊÌâ»ã×Ü ¡¾http://hi.baidu.com/yanhai/blog/item/cf67c2ce07a9f50992457e9d.html¡¿
SQL ServerµÄ²¹¶¡°æ±¾¼ì²é²»ÈçWindows ²¹¶¡°æ±¾¼ì²éÖ±½Ó£¬Ò»¸öϵͳ¹ÜÀíÔ±£¬Èç¹û²»Á˽âSQL Server°æ±¾¶ÔÓ¦µÄ²¹¶¡ºÅ£¬¿ÉÄÜÒ²»áÓöµ½Ò»µãÂé·³£¬Òò´ËÔÚÕâ˵Ã÷һϣ¬Í¨¹ýÕâÑùµÄ°ì·¨Åбð»úÆ÷Êǰ²È«µÄ°ì·¨£¬²»»á¶Ôϵͳ²úÉúÈκÎÓ°Ïì¡£
Ò»¡¢²¹¶¡°²×°¹ý³ÌÖг£¼ûÎÊÌâ
Èç¹ûÔÚ°²×°²¹¶¡µÄʱºòÓöµ½ÈçÏÂÀàËÆ´íÎó£º
1¡¢°²×°¹ý³ÌÖгöÏÖ“ÒÔǰ½øÐеijÌÐò´´½¨ÁË¹ÒÆðµÄÎļþ²Ù×÷£¬ÔËÐа²×°³ÌÐòǰ£¬±ØÐëÖØÐÂÆô¶¯”£¬Çë°´ÕÕÏÂÃæ²½Öè½â¾ö£º
a¡¢ÖØÆô»úÆ÷£¬ÔÙ½øÐа²×°£¬Èç¹û·¢ÏÖ»¹ÓиôíÎó£¬Çë°´ÏÂÃæ²½Öè b¡¢ÔÚ¿ªÊ¼->ÔËÐÐÖÐÊäÈëregedit c¡¢µ½HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager λÖà d¡¢Ñ¡ÔñÎļþ->µ¹³ö,±£´æ e¡¢ÔÚÓұߴ°¿ÚÓÒ»÷PendingFileRenameOperations£¬Ñ¡Ôñɾ³ý£¬È»ºóÈ·ÈÏ f¡¢ÖØÆô°²×°£¬ÎÊÌâ½â¾ö
Èç¹û»¹ÓÐͬÑùÎÊÌ⣬Çë¼ì²éÆäËü×¢²á±íÖÐÊÇ·ñÓиÃÖµ´æÔÚ£¬ÈçÓÐÇëɾµô¡£
2¡¢ÔÚ°²×°SQL Server SP3£¬ÓÐʱºò»á³öÏÖ£ºÎÞÂÛÓÃwindowsÈÏÖ¤»¹ÊÇ»ìºÍÈÏÖ¤£¬¶¼³öÏÖÃÜÂë´íÎóµÄÇé¿ö£¬Õâʱ²é¿´ÁÙʱĿ¼ÏµÄsqlsp.out£¬»á·¢ÏÖÒÔÏÂÃèÊö£º [TCP/IP Sockets]Specified SQL server not found. [TCP/IP Sockets]ConnectionOpen (Connect()). ÆäʵÕâÊÇSQL Server SP3µÄÒ»¸öСbug£¬ÔÚ°²×°sp3µÄʱºò£¬Ã»ÓмàÌýtcp/ip¶Ë¿Ú£¬¿ÉÒÔ°´ÕÕÒÔϲ½Öè½øÐУº
1¡¢´ò¿ªSQL server¿Í»§Æ÷ÍøÂçʵÓù¤¾ßºÍ·þÎñÆ÷ÍøÂ繤¾ß£¬È·±£ÆôÓõÄÐÒéÖаüº¬name pipe£¬²¢ÇÒλÖÃÔÚµÚһλ. 2¡¢È·±£[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo] "DSQUERY"="DBNETLIB". Èç¹ûûÓУ¬Çë×Ô¼º½¨Á¢ 3¡¢Í£Ö¹mssql. 4¡¢½øÐа²×°.
ÕâÑù¾Í¿ÉÒÔ½øÐÐÕýÈ·°²×°ÁË¡£
¶þ¡¢SQL Server²¹¶¡°æ±¾µÄ¼ì²é
SQL ServerµÄ²¹¶¡°æ±¾¼ì²é²»ÈçWindows ²¹¶¡°æ±¾¼ì²éÖ±½Ó£¬Ò»¸öϵͳ¹ÜÀíÔ±£¬Èç¹û²»Á˽âSQL Server°æ±¾¶ÔÓ¦µÄ²¹¶¡ºÅ£¬¿ÉÄÜÒ²»áÓöµ½Ò»µãÂé·³£¬Òò´ËÔÚÕâ˵Ã÷һϣ¬Í¨¹ýÕâÑùµÄ°ì·¨Åбð»úÆ÷Êǰ²È«µÄ°ì·¨£¬²»»á¶Ôϵͳ²úÉúÈκÎÓ°Ïì¡£ 1¡¢ÓÃIsql»òÕßSQL²éѯ·ÖÎöÆ÷µÇ¼µ½SQL Server£¬Èç¹ûÊÇÓÃIsql£¬ÇëÔÚcmd´°¿ÚÊäÈëisql -U sa,È»ºóÊäÈëÃÜÂ룬½øÈ룻Èç¹ûÊÇÓÃSQL²éѯ·ÖÎöÆ÷£¬Çë´Ó³ÌÐòÖÐÆô¶¯£¬ÊäÈësaºÍÃÜÂ루Ҳ¿ÉÒÔÓÃwindowsÑéÖ¤£©¡£ 2¡¢ÔÚISQLÖÐÊäÈ룺 Select @@Version£» go
»òÕßSQL²éѯ·ÖÎöÆ÷ÖÐÊäÈë(ÆäʵÈç¹û²»ÏëÊäÈ룬ֻҪ´ò¿ª°ïÖúµÄ¹ØÓھͿÉÒÔÁË:)) Select @@Versio
Ïà¹ØÎĵµ£º
ÔÚ¡¶JDBC Driver For SQL2000/2005/2008
¡·Ò»ÎÄÖУ¬ÑûÔ½éÉÜÁËÈçºÎÏÂÔØ²¢Ê¹ÓÃjdbcÁ¬½ÓSQL Server,
½ñÌìÓÐÈËÎÊÆð£¬ÈçºÎÒÔwindows¼¯³É·½Ê½Á¬½ÓSQL Server,Õâ¸öÒÔÇ°ÕæÃ»ÊÔ¹ý¡£
ÓÚÊÇ£¬´ò¿ªnetBeans²âÊÔÁËһϣ¬´úÂëÈçÏ£º
/*
* To change this template, choose Tools | Templates
* and open the template in the edit ......
USE tempdb
GO
CREATE TABLE AuctionItems
(
itemid INT NOT NULL PRIMARY KEY NONCLUSTERED,
itemtype NVARCHAR(30) NOT NULL,
whenmade INT&nb ......
1.²éѯµÄÄ£ºýÆ¥Åä
¾¡Á¿±ÜÃâÔÚÒ»¸ö¸´ÔÓ²éѯÀïÃæÊ¹Óà LIKE '%parm1%'—— ºìÉ«±êʶλÖõİٷֺŻᵼÖÂÏà¹ØÁеÄË÷ÒýÎÞ·¨Ê¹Óã¬×îºÃ²»ÒªÓÃ.
½â¾ö°ì·¨:
ÆäʵֻÐèÒª¶Ô¸Ã½Å±¾ÂÔ×ö¸Ä½ø£¬²éѯËٶȱã»áÌá¸ß½ü°Ù±¶¡£¸Ä½ø·½·¨ÈçÏ£º
a¡¢ÐÞ¸Äǰ̨³ÌÐò——°Ñ²éѯÌõ¼þµÄ¹©Ó¦ÉÌÃû³ÆÒ»À¸ÓÉÔÀ´µÄÎı¾ÊäÈë¸ÄΪÏÂÀÁб ......
UPDATe [Sale_Goods] SET [Catalog33_ID] = [Catalog].[ID]
from [Sale_Goods]
LEFT OUTER JOIN [chdy222] ON [Sale_Goods].[Code] = [chdy222].[ID]
LEFT OUTER JOIN [Catalog] ON [chdy222].[ufidaname] = [Catalog].[Name] and [Catalog].[Type]=33
WHERE [Catalog].[ID] IS NOT NULL ......