Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÖеÄIF ELSE£¨CASEÓï¾äµÄʹÓã©

----start
    ´ó¼Ò¶ÔIF ELSEÓï¾ä¿ÉÄܶ¼ºÜÊìϤ£¬ËüÊÇÓÃÀ´¶Ô¹ý³Ì½øÐпØÖƵġ£ÔÚSQLµÄÊÀ½çÖÐCASEÓï¾äÓï¾äÓÐÀàËƵÄЧ¹û¡£ÏÂÃæ¼òµ¥µÄ½éÉÜCASEÓï¾äµÄÓ÷¨¡£¿¼ÂÇÏÂÃæµÄÇé¿ö£¬¼ÙÉèÓиöuser±í£¬¶¨ÒåÈçÏ£º
CREATE TABLE USER
(
NAME VARCHAR(20) NOT NULL,---ÐÕÃû
SEX INTEGER,---ÐÔ±ð£¨1¡¢ÄÐ 2¡¢Å®£©
BIRTHDA ......

½â¾öͬʱÐÞ¸ÄͬһSQL¼Ç¼µÄÎÊÌâ

ÔÚÑ°ÕÒPowerDesignerÏà¹ØÐÅÏ¢µÄʱºòżȻ·¢ÏÖµÄ.ʹÓÃtimestamp
΢ÈíMSDNÄÚÈÝ:
timestamp (Transact-SQL)
¹«¿ªÊý¾Ý¿âÖÐ×Ô¶¯Éú³ÉµÄΨһ¶þ½øÖÆÊý×ÖµÄÊý¾ÝÀàÐÍ¡£timestamp ͨ³£ÓÃ×÷¸ø±íÐмӰ汾´ÁµÄ»úÖÆ¡£ ´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£ timestamp Êý¾ÝÀàÐÍÖ»ÊǵÝÔöµÄÊý×Ö£¬²»±£ÁôÈÕÆÚ»òʱ¼ä¡£ ÈôÒª¼Ç¼ÈÕÆÚ»òʱ¼ä£¬ÇëʹÓà datetime ......

SQL 2005 Tips Bulk data transfer sample‏

CREATE PROC [dbo].[UP_EC_JOB_UpdateAddressType] 

 @Count INT  

AS 
BEGIN 
 
 SET NOCOUNT ON 
  
 DECLARE @TransactionNumber INT  
 DECLARE @Cursor CURSOR  
 
 SET @C ......

ÈçºÎ²é¿´SQL Server²¹¶¡°æ±¾

ÈçºÎ²é¿´SQL Server²¹¶¡°æ±¾  [http://www.cnblogs.com/yitian/articles/1285021.html]
1¡¢ÓÃIsql»òÕßSQL²éѯ·ÖÎöÆ÷µÇ¼µ½SQL Server£¬Èç¹ûÊÇÓÃIsql£¬ÇëÔÚcmd´°¿ÚÊäÈëisql -U sa,È»ºóÊäÈëÃÜÂ룬½øÈ룻Èç¹ûÊÇÓÃSQL²éѯ·ÖÎöÆ÷£¬Çë´Ó³ÌÐòÖÐÆô¶¯£¬ÊäÈësaºÍÃÜÂ루Ҳ¿ÉÒÔÓÃwindowsÑéÖ¤£©¡£
2¡¢ÔÚISQLÖÐÊäÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ