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

ÈçºÎÁ¬½Óµ½Áíһ̨»úÆ÷ÉϵÄsql server 2005

 
ÈçºÎÁ¬½Óµ½Áíһ̨»úÆ÷ÉϵÄsql server 2005
 
Ò»¡¢Òª½øÐÐÁ½¸öµØ·½µÄÉèÖÃ
1         µã¿ªÊ¼—³ÌÐò—sql server 2005 –ÅäÖù¤¾ß—sql server 2005Ó¦ÓÃÅäÖÃÆ÷ ,Èçͼ£º
 
 
 
Ñ¡±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½ÓÖеĠ ½öʹÓÃtcp/ip»ò  ͬʱʹÓÃtcp/ipºÍnamed pipes
2         µã¿ªÊ¼—³ÌÐò—sql server 2005—ÅäÖù¤¾ß—sql server configuration manger
 
 
ЭÒéÑ¡ ·ñ·ñÊÇ,Ò²¾ÍÊÇÈ«²¿ÕìÌýÑ¡·ñ¡¢ÒÑÑÓ³ÙÑ¡·ñ¡¢ÒÑÆôÓÃÑ¡ÊÇ¡£È»ºóÔÙÑ¡ipµØÖ·Ñ¡Ïî
 
 
 
ÈçͼÓÐÁ½¸öipµØÖ·£¬Ò»¸öÊÇ127.0.0.1,ÁíÒ»¸öÊÇÄãÒªÅäÖõģ¬ÎªÄã»úÆ÷ÉϵÄip µØÖ·£¬tcp¶¯Ì¬¶Ë¿ÚΪ¿Õ£¬tcp¶Ë¿ÚΪ£º1433£¬ÒÑÆôÓãºÊÇ¡£
IPµØÖ·¿ÉÒÔÓÃDOSÖеÄIPCONFIGÃüÁîÀ´²é¿´¡£
µã¿ªÊ¼—ÔËÐЗcmd,È»ºóÔÚDOSÃüÁîÌáʾ·ûÏÂÊäÈëIPCONFIG¡£Èçͼ¡£
 
 
¶þ   ÉÏÃæÁ½¸ö²½ÖèÉèÖúúó£¬Èç¹ûÄãµÄ»úÆ÷ÉÏÓжà¸ösql serverÊý¾Ý¿â£¬×îºÃÒª½«ÆäËûµÄÍ£Ö¹£¬ÒÔ·ÀÖ¹ÕùÓÃ1433¶Ë¿Ú¡£
 
Èý£¬ ÖØÆô  sql server 2005·þÎñ¡£
È»ºó£¬ÄãÒ²¿ÉÒÔÔÚDOSÏÂÊÔÊÔ£¬´ÓÄãµÄ»úÆ÷ºÍÁíÒ»¸ö»úÆ÷·Ö±ðÊÔÊÔÒÔϵÄDOSÃüÁ
TELNET 192.168.3.138 1433  
ÆäÖÐTELNETºóÃæµÄΪÄãSQL SERVER2005»úÆ÷ÉϵĵÄIPµØÖ·¡£Èç¹û³öÏÖºÚÆÁ£¬¹§Ï²Äã³É¹¦À²¡£³ö¹û³öÏÖÏÂÃæµÄ´íÎóÌáʾ£¬ÇëÔÙ¿´¿´ÉÏÃæµÄÉèÖÃÊDz»Êdzö³öÁËÎÊÌâ¡£
 
 
 
 ËÄ ×î½üÒ»²½ÊǵǼ£º
 
 


Ïà¹ØÎĵµ£º

SQL Server Êý¾Ý¿âÓÅ»¯·½·¨ (Ò»)

¡¡¡¡ÎÒ¾­³£Åöµ½ÓÐÈË»áÎÊһЩÊý¾Ý¿âÓÅ»¯·½ÃæµÄÎÊÌ⣬ÎÒ¾õµÃÕâÊÇÒ»×î»ù±¾¼¼ÄÜÒªÇó£¬ÌرðÊÇʹÓÃsql server 2005£¬¶ÔÓÚsql serverµÄÓÅ»¯£¬Ê¹ÓõÄרְdba»ò¼æÖ°dbaÃǹ¤×÷¸üÇáËÉ£¬Ð§Âʸü¸ßÁË£¬µ«ÊÇ»¹ÊÇÓкܶàÐÂÈË¿ÉÄܲ»´óÁ˽⣬ÎÒÔÚÕâ¶ùдһÏÂ×î»ù±¾µÄһЩ½éÉÜ¡£
¡¡¡¡Ò»¡¢Ê×ÏȽéÉÜÒ»ÏÂsql server 2005ÖÐÓÅ»¯Êý¾ÝʱʹÓõ½µÄÁ½¸ö¹¤ ......

SQL Server2005 SynonymµÄʹÓÃ

--> Title  : SQL Server2005 SynonymµÄʹÓÃ
--> Author : wufeng4552
--> Date   : 2009-10-30
1.SynonymµÄ¸ÅÄî
¡¡  Synonym£¨Í¬Òå´Ê£©ÊÇSQL Server 2005µÄÐÂÌØÐÔ¡£¿ÉÒÔ¼òµ¥µÄÀí½âSynonymΪÆäËû對ÏóµÄ±ðÃû¡£
語·¨
CREATE SYNONYM [ schema_name_1. ] synonym_name FOR & ......

SQL ServerÖлã×ܹ¦ÄܵÄʹÓÃGROUPING,ROLLUPºÍCUBE

1.Óà CUBE »ã×ÜÊý¾Ý
 CUBE ÔËËã·ûÉú³ÉµÄ½á¹û¼¯ÊǶàάÊý¾Ý¼¯¡£¶àάÊý¾Ý¼¯ÊÇÊÂʵÊý¾ÝµÄÀ©Õ¹£¬ÊÂʵÊý¾Ý¼´¼Ç¼¸ö±ðʼþµÄÊý¾Ý¡£À©Õ¹½¨Á¢ÔÚÓû§´òËã·ÖÎöµÄÁÐÉÏ¡£ÕâЩÁб»³ÆÎªÎ¬¡£¶àάÊý¾Ý¼¯ÊÇÒ»¸ö½á¹û¼¯£¬ÆäÖаüº¬Á˸÷ά¶ÈµÄËùÓпÉÄÜ×éºÏµÄ½»²æ±í¸ñ¡£ CUBE ÔËËã·ûÔÚ SELECT Óï¾äµÄ GROUP BY ×Ó¾äÖÐÖ¸¶¨¡£¸ÃÓï¾äµÄÑ¡ÔñÁбíÓ ......

PL/SQL¿ª·¢

bulk collectÊÇ¿ÉÒÔ¿´×öÊÇÒ»ÖÖÅú»ñÈ¡µÄ·½Ê½£¬ÔÚÎÒÃǵÄplsqlµÄ´úÂë¶ÎÀï¾­³£×÷ΪintoµÄÀ©Õ¹À´Ê¹Ó᣶ÔÓÚselect id into v from .... ÊÇÒ»¸ö³£ÓõÄÓ÷¨¡£²»¹ýÕâÀïÖ»ÄÜÊÇ·µ»Øµ¥Ìõ¼Ç¼µÄʱºò£¬²ÅÄÜʹÓã¬Èç¹ûÊÇÓжàÌõ¼Ç¼ÎÒÃǾͲ»ÄÜÓÃÕâÑùµÄ·½Ê½£¬¶øÊÇʹÓÃfetchºÍÑ­»·µÄ·½Ê½£¬²»½öʹÓÃÂé·³£¬¶øÇÒÐÔÄÜÒ²µ×Ï£¬ÕâʱÎÒÃǵÄbulk coll ......

SQLÓÅ»¯

(Ò»)ÉîÈëdz³öÀí½âË÷Òý½á¹¹
¡¡¡¡Êµ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)¡£ÏÂÃæ£¬ÎÒÃǾÙÀýÀ´ËµÃ÷һϾۼ¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýµÄÇø±ð£º
¡¡¡¡Æäʵ£¬ÎÒÃǵĺºÓï×ÖµäµÄÕýÎı ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ