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

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


Ïà¹ØÎĵµ£º

SQL 2005 tips

USE tempdb
GO
CREATE TABLE AuctionItems
(
  itemid       INT          NOT NULL PRIMARY KEY NONCLUSTERED,
  itemtype     NVARCHAR(30) NOT NULL,
  whenmade     INT&nb ......

¶¨Ê±ÖØÆôSQL ServerºÍTomcat

¶¨Ê±ÖØÆôSQL ServerºÍTomcat
[http://hi.baidu.com/personnel/blog/item/020d5edf020a281248540306.html]
¶¨Ê±ÖØÆôSQL ServerºÍTomcat
2007-06-07 08:23
ÒÔǰûÓÐ×Ô¼º¹ÜÀí·þÎñÆ÷»¹²»ÖªµÀ£¬SQL Server·þÎñÆ÷µÄÄÚ´æËæ×ÅÔËÐеÄʱ¼äÔö³¤¶ø²»¶ÏÔö³¤¡£
ÓÃÁËÒ»Á½ÌìÖ®ºó·¢ÏÖ½ø³ÌÖеÄSQL ServerÒѾ­Õ¼ÓÃÁ˽ü1.3GµÄÄڴ棬ÄÚ´æÒ»¹ ......

Ìá¸ßSQLÖ´ÐÐЧÂʵļ¸µã½¨Òé:

¡¡¡¡
¡¡¡¡¡ô¾¡Á¿²»ÒªÔÚwhereÖаüº¬×Ó²éѯ;
¡¡¡¡¹ØÓÚʱ¼äµÄ²éѯ£¬¾¡Á¿²»ÒªÐ´³É£ºwhere to_char(dif_date,'yyyy-mm-dd')=to_char('2007-07-01','yyyy-mm-dd');
¡¡¡¡¡ôÔÚ¹ýÂËÌõ¼þÖУ¬¿ÉÒÔ¹ýÂ˵ô×î´óÊýÁ¿¼Ç¼µÄÌõ¼þ±ØÐë·ÅÔÚwhere×Ó¾äµÄĩβ;
¡¡¡¡from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í£¬driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖа ......

SQLÓ¦ÓÃÈÕÖ¾

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 ......

SQL ×Ö·û´®²ð·Ö

       ÓÐÕâÑùÒ»¸ö×Ö·û´®(ÖÐ,¹ú,ÖÐ,ÈËÃñ,¹ú,ÏÖ´ú¹¤Òµ»¯½ø³Ì,¹ú)
´¦Àí¹ýÖ®ºó±ä³É(ÖÐ,¹ú,ÈËÃñ,ÏÖ´ú¹¤Òµ»¯½ø³Ì)
 
        ÒÔÏÂÊÇÎҵķ½·¨,ÓÐʲô²»¶ÔµÄµØ·½»¹Çë¸÷λָµã
 ------------------ɾ³ýÖظ´µÄ×Ö·û
 declare
@v1 nvarchar
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ