Common Database scripts

Sqlserver:
1. Modify the database sorting rule and change it to the Chinese language (if it is in English, it may be a problem to insert the insert statement directly into the Chinese language. You need to use Insert into table_1 values (N'Chinese ')Method)
Alter database master collate chinese_prc_ci_as;
All fields in this database are valid after modification.

2. Modify the sorting rules of a specified field:
Select 'alter table' + O. Name + 'alter column' + C. Name + 'charcol' +
T. Name + '(' + Cast (C. length as varchar) + ') Collate SQL _latin1_general_cp1_ci_as'
From DBO. syscolumns C, DBO. sysobjects o, DBO. policypes t
Where o. ID = C. ID and O. type = 'U' and C. Type = T. Type