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


Ïà¹ØÎĵµ£º

PowerDesignerÉú³ÉÊý¾Ý¿â½¨±íSQL½Å±¾Ê±È¥Ë«ÒýºÅ

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

SQL Server×Ô´ø±¸·ÝÕû¸öÊý¾Ý¿â½Å±¾¹¤¾ß scptxfr.exe


Ê×ÏÈÔÚsqlserverµÄ°²×°Â·¾¶Ï£¬È磺D:\Program Files\Microsoft SQL
Server\MSSQL\£¬ÕÒµ½ÎļþÃûÊÇscptxfr.exeµÄÎļþ,ÀûÓÃÃüÁîÐй¤¾ß£º¾ßÌåÓ÷¨ÈçÏ£º
D:\PROGRA~1\MICROS~2\MSSQL\>scptxfr/?
ÃüÁîÐÐÓï·¨:
SCPTXFR /s
<·þÎñÆ÷> /d <Êý¾Ý¿â> {[/I] | [/P <ÃÜÂë>]}
    &n ......

SQL Server±¨´íChinese_PRC_90_CI_AS

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
ÖÐÎÄ£¨Ïã¸ÛÌØ±ðÐ ......

sql ѧϰ

Ò»¡¢ÈçºÎ´ÓselectµÄ²éѯ½á¹ûÖÐÔÙ´ÎÔËË㣿
µÚÒ»²½£º
´Ö²éѯ¡£Ê×ÏÈÐèÒª½«µÚÒ»²ã²éѯŪ¶Ô£¬¹ØÏµÅªÇå³þ¡£
select sum(quantity) total ,price_water,price_pollute from pay_water where time_pay >='2010-02-01 00:00:00.000' and time_pay <'2010-02-28 23:59:59.000'
group by price_water,price_pollute
µÚ¶þ²½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ