Pages

Friday, March 10, 2006

SQL - COLLATIONPROPERTY 更改

SELECT COLLATIONPROPERTY('Chinese_Taiwan_Stroke_CI_AS','CodePage') as codepage
SELECT COLLATIONPROPERTY('Chinese_Taiwan_Stroke_CI_AS','LCID') as codepage

SELECT SERVERPROPERTY('collation')
--RebuildM.exe 可以重新修改Server的定序設定

SELECT DATABASEPROPERTYEX(‘xxx’, ‘collation’)
--透過
Alter Database MTF01 Collate Chinese_Taiwan_Stroke_CI_AS
--修改table定序

eng - flock 聚集

KK[flak]
vi. 聚集;成群地


In warm weather, people enjoy water sports. Lovers of surfing, sailing and scuba diving flock to the ocean.

Friday, March 03, 2006

SQL - Shrink Log

--backup transaction log - TRUNCATE ONLY
BACKUP LOG Northwind WITH TRUNCATE_ONLY;


--shrink database - TRUNCATE ONLY
DBCC shrinkdatabase (N'Northwind', TRUNCATEONLY );


--check database status
sp_helpdb @dbname = 'Northwind';


--change database recovery mode - SIMPLE
ALTER DATABASE Northwind
SET RECOVERY
SIMPLE;

Eng - diarrhoea 腹瀉






n. 腹瀉

Many people who travel away from home experience travellers' diarrhoea.

*注意拼法有兩個「r」,「ho」不發音。