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

SQL Server 2005ÆôÓÃsaÕ˺Å


SQL Server 2005ÆôÓÃsaÕ˺Å
ÆôÓÃsaÓû§ºÍÔ¶³ÌÁ¬½Ó 
²Ëµ¥Start->Microsoft SQL Server 2005->Configuration Tools->SQL Server Configuration Manager 
Ñ¡ÖÐSQL Server 2005 Network Configuration 
ÔÚÓұߵÄTCP/IPÉϵãÓÒ¼ü£¬enabled 
²Ëµ¥Start->Microsoft SQL Server 2005->SQL Server Management Studio Express 
µÇ¼¶Ô»°¿òÖ±½Óµãconnect½øÈ¥ 
ÔÚ×ó±ß¸ù½áµã£¨yourpcSQLEXPRESS£©ÉϵãÓÒ½¨ 
Ñ¡properties 
×ó±ßÑ¡security£¬ÓÒ±ßÑ¡ÖÐSQL Server and Windows Authentication Mode 
¹¤¾ßÀ¸µÚÒ»¸ö°´Å¥new query 
ÔÚ²éѯ´°¿ÚÖÐÖ´ÐР
exec sp_password NULL,'yourpassword','sa' 
alter login sa enable 
¹Ø±ÕSQL Server Management Studio Express 
²Ëµ¥Start->Microsoft SQL Server 2005->Configuration Tools->SQL Server Configuration Manager 
Ñ¡ÖÐSQL Server 2005 Services 
ÔÚÓұߵÄSQL Server(SQLEXPRESS)ÉϵãÓÒ¼ü£¬Restart 
ÓÃsaµÇ¼ 
²Ëµ¥Start->Microsoft SQL Server 2005->SQL Server Management Studio Express 
µÇ¼¶Ô»°¿òAuthenticationÑ¡ÔñSQL Server Authentication 
µãconnect 
Èç¹û²»³öÒâÍâ,Ó¦¸Ã¿ÉÒԳɹ¦µÇ¼¡£ 
´Ó SQL Server Management Studio ÖØÐÂÆô¶¯ SQL Server 
ÔÚ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖУ¬ÓÒ¼üµ¥»÷ÄúµÄ·þÎñÆ÷£¬ÔÙµ¥»÷“ÖØÐÂÆô¶¯”¡£Èç¹ûÔËÐÐÓÐ SQL Server ´úÀí£¬ÔòÒ²±ØÐëÖØÐÂÆô¶¯¸Ã´úÀí¡£
 Ê¹Óà Transact-SQL ÆôÓà sa µÇ¼ÕÊ»§ 
Ö´ÐÐÏÂÁÐÓï¾äÒÔÆôÓà sa ÃÜÂë²¢·ÖÅäÒ»¸öÃÜÂë¡£
 ¸´ÖÆ´úÂë
ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '<password>' ;
GO
 Ê¹Óà Management Studio ÆôÓà sa µÇ¼ÕÊ»§ 
ÔÚ¶ÔÏó×ÊÔ´¹ÜÀíÆ÷ÖУ¬ÒÀ´ÎÕ¹¿ª“°²È«”¡¢“µÇ¼Ãû”£¬ÓÒ¼üµ¥»÷“sa”£¬ÔÙµ¥»÷“ÊôÐÔ”¡£
ÔÚ“³£¹æ”Ò³ÉÏ£¬Äú¿ÉÄÜÐèҪΪ sa µÇ¼Ãû´´½¨ÃÜÂ벢ȷÈϸÃÃÜÂë¡£
Ôړ״̬”Ò³µÄ“µÇ¼”²¿·ÖÖУ¬µ¥»÷“ÆôÓÔ£¬È»ºóµ¥»÷“È·¶¨”¡£
Section 2
ÒªÈÃdeveloper ¿ÉÒÔͨ¹ýnetwork login µ½SQL Server 2005¾ÍÒª½øÐÐÈçÏÂcofiguration¡£
Start Menu -> Microsoft SQL Server 2005 -> Configur


Ïà¹ØÎĵµ£º

¹ØÓÚSQLÖÐcountµÄЧÂÊ

COUNT(*)ÓëCOUNT(COL)
ÍøÉÏËÑË÷ÁËÏ£¬·¢ÏÖ¸÷ÖÖ˵·¨¶¼ÓУº
±ÈÈçÈÏΪCOUNT(COL)±ÈCOUNT(*)¿ìµÄ£»
ÈÏΪCOUNT(*)±ÈCOUNT(COL)¿ìµÄ£»
»¹ÓÐÅóÓѺܸãЦµÄ˵µ½Õâ¸öÆäʵÊÇ¿´ÈËÆ·µÄ¡£
ÔÚ²»¼ÓWHEREÏÞÖÆÌõ¼þµÄÇé¿öÏ£¬COUNT(*)ÓëCOUNT(COL)»ù±¾¿ÉÒÔÈÏΪÊǵȼ۵ģ»
µ«ÊÇÔÚÓÐWHEREÏÞÖÆÌõ¼þµÄÇé¿öÏ£¬COUNT(*)»á±ÈCOUNT(COL)¿ì·Ç³£¶à ......

SQL ServerÖеÄÃüÃû¹ÜµÀ(named pipe)¼°ÆäʹÓÃ

1. ʲôÊÇÃüÃû¹ÜµÀ£¿
ÓëTCP/IP£¨´«Êä¿ØÖÆÐ­Òé»òinternetЭÒ飩һÑù£¬ÃüÃû¹ÜµÀÊÇÒ»ÖÖͨѶЭÒé¡£ËüÒ»°ãÓÃÓÚ¾ÖÓòÍøÖУ¬ÒòΪËüÒªÇó¿Í»§¶Ë±ØÐë¾ßÓзÃÎÊ·þÎñÆ÷×ÊÔ´µÄȨÏÞ¡£
Òª½âÊÍÕâ¸öÎÊÌ⣬ÎÒ»¹ÊÇժ¼΢Èí¹Ù·½µÄ×ÊÁϱȽϺÃ
http://msdn.microsoft.com/zh-cn/library/ms187892.aspx
ÈôÒªÁ¬½Óµ½ SQL Server Êý¾Ý¿âÒýÇæ£¬±ØÐëÆô ......

SQL Server2005ÖеÄSQL ServerÉí·ÝÑéÖ¤µÄÉèÖÃ


¸Õ¸Õ×°ÁËSQL2008£¬ÅäÖÃÁËһϣ¬ÔÚÍøÉÏÕÒµ½Õâ¸ö½Ì³Ì£¬¾õµÃ²»´í£¬×ªÔØÑ§Ï°
1¡¢ ¸ü¸ÄTCP/IPÁ¬½ÓΪÆôÓÃ
2¡¢ µÇ¼ £¬ ÐÞ¸Ä2¸öµØ·½
    a) Éí·ÝÑéÖ¤·½Ê½£¨»ìºÏģʽ£©
        ͼһ£ºÊ×ÏÈʹÓÃwindowsÉí·ÝµÇ¼£¨×¢Ò⣬ ·þÎñÆ÷Ãû³Æ±ØÐëÌîдÕýÈ·£©
     ......

oracle sql*plus set &spool½éÉÜ(¶þ)

Oracle spool Ó÷¨Ð¡½á[°ëת°ë¼Ó]
¹ØÓÚSPOOL(SPOOLÊÇSQLPLUSµÄÃüÁ²»ÊÇSQLÓï·¨ÀïÃæµÄ¶«Î÷¡£)
¶ÔÓÚSPOOLÊý¾ÝµÄSQL£¬×îºÃÒª×Ô¼º¶¨Òå¸ñʽ£¬ÒÔ·½±ã³ÌÐòÖ±½Óµ¼Èë,SQLÓï¾äÈ磺
select empno||','||ename||','||sal from emp;
spool³£ÓõÄÉèÖÃ
set colsep' ';¡¡¡¡¡¡ //ÓòÊä³ö·Ö¸ô·û
set echo off;¡¡¡¡¡¡¡¡//ÏÔʾstartÆô¶¯µ ......

sql¾«Õ¿·ÖÒ³Óï¾ä

select top Ò³´óС *
from table1
where id>
      (select max (id) from
      (select top ((Ò³Âë-1)*Ò³´óС) id from table1 order by id) as T) order by id ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ