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

SQL Server ¹ÜÀí³£ÓõÄSQLºÍT SQL

1. ²é¿´Êý¾Ý¿âµÄ°æ±¾  
  select @@version
 
  ³£¼ûµÄ¼¸ÖÖSQL SERVER´ò²¹¶¡ºóµÄ°æ±¾ºÅ:
 
  8.00.194   Microsoft SQL Server 2000
  8.00.384   Microsoft SQL Server 2000 SP1
  8.00.532   Microsoft SQL Server 2000 SP2
  8.00.760   Microsoft SQL Server 2000 SP3
  8.00.818   Microsoft SQL Server 2000 SP3 w/ Cumulative Patch MS03-031
  8.00.2039 Microsoft SQL Server 2000 SP4  
 
2. ²é¿´Êý¾Ý¿âËùÔÚ»úÆ÷²Ù×÷ϵͳ²ÎÊý  
  exec master..xp_msver
 
3. ²é¿´Êý¾Ý¿âÆô¶¯µÄ²ÎÊý      
  sp_configure
     
4. ²é¿´Êý¾Ý¿âÆô¶¯Ê±¼ä      
  select convert(varchar(30),login_time,120) from master..sysprocesses where spid=1
 
  ²é¿´Êý¾Ý¿â·þÎñÆ÷ÃûºÍʵÀýÃû
  print 'Server Name...............: ' + convert(varchar(30),@@SERVERNAME)      
  print 'Instance..................: ' + convert(varchar(30),@@SERVICENAME)    
5. ²é¿´ËùÓÐÊý¾Ý¿âÃû³Æ¼°´óС
  sp_helpdb
 
  ÖØÃüÃûÊý¾Ý¿âÓõÄSQL
  sp_renamedb 'old_dbname', 'new_dbname'
 
6. ²é¿´ËùÓÐÊý¾Ý¿âÓû§µÇ¼ÐÅÏ¢
  sp_helplogins
 
  ²é¿´ËùÓÐÊý¾Ý¿âÓû§ËùÊôµÄ½ÇÉ«ÐÅÏ¢  
  sp_helpsrvrolemember
 
  ÐÞ¸´Ç¨ÒÆ·þÎñÆ÷ʱ¹ÂÁ¢Óû§Ê±,¿ÉÒÔÓõÄfix_orphan_user½Å±¾»òÕßLoneUser¹ý³Ì
 
  ¸ü¸Äij¸öÊý¾Ý¶ÔÏóµÄÓû§ÊôÖ÷
  sp_changeobjectowner [@objectname =] 'object', [@newowner =] 'owner'
 
  ×¢Òâ: ¸ü¸Ä¶ÔÏóÃûµÄÈÎÒ»²¿·Ö¶¼¿ÉÄÜÆÆ»µ½Å±¾ºÍ´æ´¢¹ý³Ì¡£
 
  °Ñһ̨·þÎñÆ÷ÉϵÄÊý¾Ý¿âÓû§µÇ¼ÐÅÏ¢±¸·Ý³öÀ´¿ÉÒÔÓÃadd_login_to_aserver½Å±¾
 
  ²é¿´Ä³Êý¾Ý¿âÏÂ,¶ÔÏó¼¶Óû§È¨ÏÞ
  sp_helprotect
 
7. ²é¿´Á´½Ó·þÎñÆ÷      
  sp_helplinkedsrvlogin
 
  ²é¿´Ô¶¶ËÊý¾Ý¿âÓû§µÇ¼ÐÅÏ¢  
  sp_helpremotelogin
 
8.²é¿´Ä³Êý¾Ý¿âÏÂij¸öÊý¾Ý¶ÔÏóµÄ´óС
  sp_spaceused


Ïà¹ØÎĵµ£º

1433¶Ë¿ÚÓ³Éä ¼ÜÉèsql server [¾­µä]

1433¶Ë¿ÚÓ³Éä ¼ÜÉèsql server
¡¾×ª¡¿ http://blog.csdn.net/lee576/archive/2007/11/12/1880001.aspx
¹ØÓÚͨ¹ýÍâÍøÁ¬½ÓÄÚÍøSQL Server·þÎñÆ÷µÄ·½·¨
      ½üÈÕ£¬ÔÚÂÛ̳ÉÏ¿´µ½µÄÓйØSQL ServerÔ¶³ÌÁ¬½ÓµÄÎÄÕºó£¬ÕæµÄÊÜÒæÁ¼¶à¡£Ò»Ö±ÒÔÀ´À§»óÁËÒѾõĹØÓÚ´ÓÍâÍøÈçºÎÁ¬½Óµ½ÄÚÍøµÄSQL Server·þÎñÆ ......

SQL SERVER ²éѯÓï¾äÓÅ»¯(ת)

1¡¢  ÓóÌÐòÖУ¬±£Ö¤ÔÚʵÏÖ¹¦ÄܵĻù´¡ÉÏ£¬¾¡Á¿¼õÉÙ¶ÔÊý¾Ý¿âµÄ·ÃÎÊ´ÎÊý£»Í¨¹ýËÑË÷²ÎÊý£¬¾¡Á¿¼õÉÙ¶Ô±íµÄ·ÃÎÊÐÐÊý,×îС»¯½á¹û¼¯£¬´Ó¶ø¼õÇáÍøÂ縺µ££»Äܹ»·Ö¿ªµÄ ²Ù×÷¾¡Á¿·Ö¿ª´¦Àí£¬Ìá¸ßÿ´ÎµÄÏìÓ¦ËÙ¶È£»ÔÚÊý¾Ý´°¿ÚʹÓÃSQLʱ£¬¾¡Á¿°ÑʹÓõÄË÷Òý·ÅÔÚÑ¡ÔñµÄÊ×ÁУ»Ëã·¨µÄ½á¹¹¾¡Á¿¼òµ¥£»ÔÚ²éѯʱ£¬²»Òª¹ý¶àµØÊ¹ÓÃͨÅä·û ÈçSELE ......

SQLÓïÑÔ»ù´¡£¨Ò»£©


SQL*PLUSµÄʹÓÃ
1¡¢Í˳öSQL*PLUS
   EXIT£ºÖÕÖ¹SQL*PLUS£¬²¢½«¿ØÖÆÈ¨½»»¹¸øOS¡£
2¡¢±à¼­ÃüÁî
1) List»òL£ºÏÔʾ»º³åÇøÖÐËùÓеÄÐС£
SQL> list
  1  select
  2  *
  3* from dept   --×¢£º*´ú±íµ±Ç°ÐС£ ......

SQL Server´æ´¢¹ý³ÌµÄ±àдºÍÓÅ»¯´ëÊ©

¡¡¡¡ÔÚÊý¾Ý¿âµÄ¿ª·¢¹ý³ÌÖУ¬¾­³£»áÓöµ½¸´ÔÓµÄÒµÎñÂß¼­ºÍ¶ÔÊý¾Ý¿âµÄ²Ù×÷£¬Õâ¸öʱºò¾Í»áÓÃSPÀ´·â×°Êý¾Ý¿â²Ù×÷¡£Èç¹ûÏîÄ¿µÄSP½Ï¶à£¬ÊéдÓÖûÓÐÒ»¶¨µÄ¹æ·¶£¬½«»áÓ°ÏìÒÔºóµÄϵͳά»¤À§ÄѺʹóSPÂß¼­µÄÄÑÒÔÀí½â£¬ÁíÍâÈç¹ûÊý¾Ý¿âµÄÊý¾ÝÁ¿´ó»òÕßÏîÄ¿¶ÔSPµÄÐÔÄÜÒªÇóºÜ£¬¾Í»áÓöµ½ÓÅ»¯µÄÎÊÌ⣬·ñÔòËÙ¶ÈÓпÉÄܺÜÂý£¬¾­¹ýÇ×Éí¾­Ñ飬һ¸ö¾­ ......

powerdesignerÉú³ÉsqlÈ¥µôË«ÒýºÅ

ʹÓÃPowerDesignerÉú³ÉÊý¾Ý¿â
½¨±íSQL
½Å
±¾Ê±£¬ÓÈÆäÊÇOracleÊý¾Ý¿âʱ£¬±íÃûÒ»°ã»á´øÒýºÅ¡£Æäʵ¼ÓÒýºÅÊÇPL/SQLµÄ¹æ·¶£¬Êý¾Ý¿â»áÑϸñ°´ÕÕ“”ÖеÄÃû³Æ½¨±í£¬Èç¹ûûÓГ”£¬»á°´ÕÕ
ORACLEĬÈϵÄÉèÖý¨±í£¨DBA
STUDIOÀïÃæ£©£¬Ä¬ÈÏÊÇÈ«²¿´óд£¬ÕâÑù£¬ÔÚORACLEÊý¾Ý¿âÀïµÄ×ֶξÍÈç“Column_1&rdqu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ