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.

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」不發音。