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定序