SQL Server database modifications are case-sensitive

The following statement is to set whether the SQL Server database is case-sensitive: (Table name and database field name)

--Modify database is case insensitive
ALTER DATABASE name COLLATE chinese_prc_ci_as

such as: Alter DATABASE ZJK_CX COLLATE chinese_prc_ci_as
--Modify Database case sensitivity
ALTER DATABASE name COLLATE chinese_prc_cs_as

such as: Alter DATABASE ZJK_CX COLLATE chinese_prc_cs_as

The following is the case of a database row record: (typically used in a where condition at query time)

--Case insensitive

ALTER DATABASE name ALTER COLUMN field Name field type COLLATE chinese_prc_ci_as

Example: ALTER DATABASE ZJK_CX ALTER COLUMN dbconn varchar ($) COLLATE chinese_prc_ci_as

--Case sensitive

ALTER DATABASE name ALTER COLUMN field Name field type COLLATE chinese_prc_cs_as

Example: ALTER DATABASE ZJK_CX ALTER COLUMN dbconn varchar ($) COLLATE chinese_prc_cs_as