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

Sql Server²é¿´ËùÓÐÊý¾Ý¿âÃû,±íÃû,×Ö¶ÎÃûSQL

1.»ñÈ¡ËùÓÐÊý¾Ý¿âÃû:
SELECT Name from Master..SysDatabases ORDER BY Name
2.»ñÈ¡ËùÓбíÃû:
SELECT Name from DatabaseName..SysObjects Where XType='U' ORDER BY Name
XType='U':±íʾËùÓÐÓû§±í;
XType='S':±íʾËùÓÐϵͳ±í;
3.»ñÈ¡ËùÓÐ×Ö¶ÎÃû:
SELECT Name from SysColumns WHERE id=Object_Id('TableName')
ÔÚMS Sql ServerÖпÉÒÔÄܹýÒÔϵķ½·¨²éѯ³ö´ÅÅÌ¿Õ¼äµÄʹÓÃÇé¿ö¼°¸÷Êý¾Ý¿âÊý¾ÝÎļþ¼°ÈÕÖ¾ÎļþµÄ´óС¼°Ê¹ÓÃÀûÓÃÂÊ:
1¡¢²éѯ¸÷¸ö´ÅÅÌ·ÖÇøµÄÊ£Óà¿Õ¼ä£º
         Exec master.dbo.xp_fixeddrives  
2¡¢²éѯÊý¾Ý¿âµÄÊý¾ÝÎļþ¼°ÈÕÖ¾ÎļþµÄÏà¹ØÐÅÏ¢£¨°üÀ¨Îļþ×é¡¢µ±Ç°Îļþ´óС¡¢Îļþ×î´óÖµ¡¢ÎļþÔö³¤ÉèÖá¢ÎļþÂß¼­Ãû¡¢Îļþ·¾¶µÈ£©  
      select * from [Êý¾Ý¿âÃû].[dbo].[sysfiles]
      ת»»Îļþ´óСµ¥Î»ÎªMB£º
     select name, convert(float,size) * (8192.0/1024.0)/1024. from [Êý¾Ý¿âÃû].dbo.sysfiles
3¡¢²éѯµ±Ç°Êý¾Ý¿âµÄ´ÅÅÌʹÓÃÇé¿ö£º
     Exec sp_spaceused
£´¡¢²éѯÊý¾Ý¿â·þÎñÆ÷¸÷Êý¾Ý¿âÈÕÖ¾ÎļþµÄ´óС¼°ÀûÓÃÂÊ
     DBCC SQLPERF(LOGSPACE)
 


Ïà¹ØÎĵµ£º

¹ØÓÚsql server ´úÀí£¨ÒѽûÓôúÀíxp£©

Ö¢×´£º
SQL SERVER2005ÀïÃ棬Æô¶¯SQL´úÀí·þÎñ£¬Æô¶¯Õý³££¬µ«ÊÇÔÚsql server ´úÀí»¹ÊÇÏÔʾÒѽûÓôúÀí xp
ÔÚManagement StudioÖÐн¨Î¬»¤¼Æ»®Ê±£¬ÌáʾÒÔÏ´íÎóÐÅÏ¢£º
“´úÀíXP”×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö±»¹Ø±Õ¡£ÏµÍ³¹ÜÀíÔ±¿ÉÒÔʹÓÃsp_configureÀ´ÆôÓÓ´úÀíXP”¡£ÓйØÆôÓÓ´úÀíXP ......

sql server 2005 ÅäÖÃÔ¶³ÌÁ¬½Ó

ÒÔÏÂ˵Ã÷¾ùÕë¶ÔÆóÒµ°æ»òÕß¿ª·¢°æ£»
1.¿ªÆôsql server ʵÀýµÄÔ¶³ÌÁ¬½Ó£»
    “¿ªÊ¼”-->“³ÌÐò”-->“Microsoft SQL Server 2005”-->“ÅäÖù¤¾ß”-->“SQL Server ÍâΧӦÓÃÅäÖÃÆ÷”-->“·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÃÆ÷”--> ......

MS SQL 2000/2005 Ð޸ıíËùÓÐÕß´æ´¢¹ý³Ì

Create PROCEDURE [dbo].[ChangeObjectOwner]
@OldOwner as NVARCHAR(128),
@NewOwner as NVARCHAR(128)
AS
DECLARE @Name   as NVARCHAR(128)
DECLARE @Owner  as NVARCHAR(128)
DECLARE @OwnerName as NVARCHAR(128)
DECLARE curObject CURSOR FOR
select 'Name' = name,
 'Owner'&n ......

SQL Server SQLÓï¾äµ¼Èëµ¼³ö´óÈ«

/*******  µ¼³öµ½excel
EXEC master..xp_cmdshell ’bcp SettleDB.dbo.shanghu out c:\temp1.xls -c -q -S"GNETDATA/GNETDATA" -U"sa" -P""’
/***********  µ¼ÈëExcel
SELECT *
from OpenDataSource( ’Microsoft.Jet.OLEDB.4.0’,
  ’Data Source="c:\test.xls";User ......

linq to sql ÖдÓdbmlÎļþÖд´½¨Êý¾Ý¿â

        ½ñÌìºÜÓôÃÆ,ʵÑéÊҵķþÎñÆ÷¶«Î÷¶¼Ã»ÓÐÁË,¶øÎÒµÄÊý¾Ý¿âÓÖÔÚÄÄÀï,ÎÒÓÖûÓб¸·Ý,°ÑÎÒÒÖÓôµÄÒªÃü,ÐÒ¿÷ÎÒÓõÄlinq to sql.×ÐϸÏëÏë,ËûµÄdbmlÎļþ»ù±¾°üº¬ÁËÊý¾Ý¿âµÄËùÓÐÄÚÈÝ,ËùÒÔ,Ò»¶¨Óа취´ÓdbmlÎļþÖд´½¨Êý¾Ý¿â!
        Ñо¿ÁËÒ»¶ÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ