Daily Backup Batch Script

C:\WINDOWS\system32\ntbackup.exe backup "@C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Windows NT\NTBackup\data\EPDEV01_02_daily.bks" /a /d "Set created %date% at %time%" /v:no /r:no /rs:no /hc:off /m daily /j "EPDEV01_02_daily" /l:s /f "G:\NTBackup\Daily\EPDEV01_02_daily.%date:~-4%%date:~4,2%%date:~7,2%.bkf"

Weekly Backup Batch

C:\WINDOWS\system32\ntbackup.exe backup "@C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Windows NT\NTBackup\data\EPDEV01_02_daily.bks" /a /d "Set created %date% at %time%" /v:no /r:no /rs:no /hc:off /m daily /j "EPDEV01_02_daily" /l:s /f "G:\NTBackup\Daily\EPDEV01_02_daily.%date:~-4%%date:~4,2%%date:~7,2%.bkf"

建立Language Converter的Batch File

Build a xxx.bat file with the following scripts inside the file:
native2ascii -encoding UTF-8 language_zh_HK.txt language_zh_HK.properties

兩句好用既SQL insert into ... select ... , create ... as select ...

[insert into ... select ... ]
=================
INSERT INTO Store_Information (store_name, Sales, Date)
SELECT store_name, Sales, Date
FROM Sales_Information
WHERE Year(Date) = 1998

[create ... as select ]
==============
create table t1 as
select
store_name,
avg(quantity) qty
from
store join sales using (store_key)
group by store_name;