How to view SQL Server 2000 Code Page

xiaoxiao2021-03-06  19

- View a DB of CollationSelect DatabasePropertyEx ('Northwind', 'Collation')

- a view corresponding to the collation code pageSELECT COLLATIONPROPERTY ( 'Chinese_Taiwan_Stroke_CI_AS', 'CodePage') - DB of viewing a code pageselect COLLATIONPROPERTY (convert (nvarchar (100), DATABASEPROPERTYEX ( 'Northwind', 'Collation')), 'CodePage') - Refer to SELECT * from :: Fn_HelpCollations ()

转载请注明原文地址:https://www.9cbs.com/read-77157.html

New Post(0)