Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

½«Êý¾Ý¿â±íÖеÄÊý¾ÝתΪsqlÖеÄinsertÓï¾ä

 set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
--½«±íÊý¾ÝÉú³ÉSQL½Å±¾µÄ´æ´¢¹ý³Ì ......

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

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

SQL 2005 ´´½¨Ô¼Êø

²Î¼û¡¶SQL Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ¡· ÖÜÆæ
 
SQL ServerÖÐÓÐÎåÖÖÔ¼ÊøÀàÐÍ£¬·Ö±ðÊÇCHECKÔ¼Êø¡¢DEFAULTÔ¼Êø¡¢PRIMARY KEYÔ¼Êø¡¢FOREIGN KEYÔ¼ÊøºÍUNIQUEÔ¼Êø¡£
 
1.       CHECKÔ¼Êø£º
CHECKÔ¼ÊøÓÃÓÚÏÞÖÆÊäÈëÒ»Áлò¶àÁеÄÖµµÄ·¶Î§£¬Í¨¹ýÂß¼­±í´ïʽÀ´ÅжÏÊý¾ ......

SQLÓï¾äÓÅ»¯

SQLÓï¾äµÄÓÅ»¯¾ÍÊǽ«ÐÔÄܽϵ͵ÄSQLÓï¾äת»»´ï³ÉͬÑùÄ¿µÄÐÔÄÜÓÅÒìµÄSQLÓï¾ä
ÏÂÃæÎÒÃÇÒ»ÆðÀ´¿´¿´Ò»Ð©¿ÉÒÔÓÅ»¯SQLµÄ·½·¨£¬Ï£Íû´ó¼Ò¶àÌá³öÒâ¼ûÎÒÃǹ²Í¬Ñ§Ï°»òÕßÊÇ´ó¼ÒÓÐʲôºÃµÄÓÅ»¯·½·¨¿ÉÒÔÌá³öÀ´¹²Ïíһϡ£
 
µÚÒ»ÖÖÓÅ»¯£¨Ê¹ÓÃÖ¸¶¨ÁдúÌæ”*”£©
       ʹÓÓ*&rdquo ......

Sql2005/08 ±í½á¹¹ SQL Óï¾ä

SELECT
(case when a.colorder=1 then d.name
--+'('+cast(h.value as nvarchar)+')'
else '' end)±íÃû,
a.colorder ×Ö¶ÎÐòºÅ,
a.name ×Ö¶ÎÃû,
isnull(g.[value],'') AS ×Ö¶Î˵Ã÷,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '¡Ì'else '' end) ±êʶ,
(case whe ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ