Maxwell Tech Note

一般用户或者DBA都會經常需要檢查所有的DB或Table的容量狀況 在MS SQL Server 中查詢的方法有有 方法1: select object_name(id) tablename,8*reserved/1024 reserved, rtrim(8*dpages/1024)+'Mb' used,8*(reserved-dpages)/1024 unused, 8*dpages/1024-rows/1024*minlen/1024 free,rows,* from sysindexes where indid=1 order by reserved desc 方法2: exec sp_MSforeachtable "exec sp_spaceused '?'" 註解 系统預存函數sp_MSforeachtable和sp_MSforeachdb,是Microsoft提供的兩個不公開的函數,從MS SQL Server 6.5開始存放在SQL Server的MASTER DB中 http://www.seekeep.com/html/computer/database/mssql/200802/628.html

Loader : use to load *.swf , all image (jpg,png,gif) URLLoader : use to load text-doc (xml,txt,php,jsp,asp) How to use: Loader: var _ldr:Loader = new Loader(); _ldr.load(new URLRequest(' $imagePaph ' )); _ldr.addEventListener(Event.COMPLETE,onURLLoaded); addChild(_ldr); function onURLLoaded (event:Event):void{ trace("URLLoader Complete"); } $imagePath: can be the file path in local or file url in Internet URLLoader: var _urlLdr:URLLoader =new URLLoader(); var request:URLRequest = new URLRequest(" $docPaph "); _urlLdr.addEventListener(Event.COMPLETE,onURLLoaded); _urlLdr.load(request) function onURLLoaded (event:Event):void{ var docData:String=event.target.data; trace("URLLoader Complete"); } $docPath: can be the file path in local or file url in Internet

Google 提供了一個java Script 可以讓自己的網站用google翻譯成你要的語言 不只是可以用在blog上 也可以用在個人或公司的網站上 不過翻譯的好不好 見仁見智囉 詳情可以看這邊 google翻譯

MS Visual Studio提供多國語系 Package MS Visual Studio提供多國語系 Package

http://www.webservicex.net/CurrencyConvertor.asmx In Visual Studio Web References import http://www.webservicex.net/CurrencyConvertor.asmx In Code Imports ProjectName.net.webservicex.www Dim a As CurrencyConvertor = New CurrencyConvertor Dim Rate as double= a.ConversionRate(Currency.USD, Currency.TWD)