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)
Ïà¹ØÎĵµ£º
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 ......
/******* µ¼³öµ½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 ......
http://inthirties.com:90/thread-1202-1-1.html
v$sqltext
´æ´¢µÄÊÇÍêÕûµÄSQL,SQL±»·Ö¸î
SQL> desc v$sqltext
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS ......
SQL Server 2005±¨ÁËÕâô¸ö´í£ºCannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "Chinese_PRC_90_CI_AS" in the like operation.
ºó²éÖ¤£¬ÕâÊÇÓÉÓÚÁ½¸ö×ö±È½ÏµÄÁеÄÅÅÐò·½Ê½²»Í¬£¬ÖÐÎÄÓкܶàÖÖÅÅÐò·½Ê½£¬¶ÔÓ¦ÈçÏ£º
ÖÐÎÄ£¨Ïã¸ÛÌØ±ðÐÐÕþÇø£©
Chinese_Hong_Kong_Stroke_90_CI_AS
ÖÐÎÄ£¨Ïã¸ÛÌØ±ðÐ ......