How does SQL SERVER determine whether a field contains uppercase letters?

SQL statements are case-insensitive by default, so the statement:

SQL code
SELECT * FROM RecEngineBizInfo WHERE RecEngineBizName = 'qq'
And
SQL code
SELECT * FROM RecEngineBizInfo WHERE RecEngineBizName = 'qq'

The results are the same.

The script to check whether A field contains uppercase letters A is:
SQL code
Select * from RecEngineBizInfo where RecEngineBizName collate Chinese_PRC_CS_AS_WS like '% A %'
Www.2cto.com
The script to check whether a field contains uppercase letters is:
SQL code
SELECT * FROM RecEngineBizInfo rebi
WHERE rebi. RecEngineBizName COLLATE Chinese_PRC_CS_AS
Like '% [ABCDEFGHIJKLMNOPQRSTUVWXYZ] %'

The script to check whether a field contains two consecutive uppercase letters is:
SQL code
SELECT * FROM RecEngineAttributeInfo reai
WHERE reai. ZhiLing COLLATE Chinese_PRC_CS_AS
Like '% [ABCDEFGHIJKLMNOPQRSTUVWXYZ] [ABCDEFGHIJKLMNOPQRSTUVWXYZ] %'

And so on.