If SQL Server collation is case-sensitive and the database is case-insensitive, will the queries be case-sensitive or not?

Question

If the sql server server collation is case-sensitive and the database is case-insensitive, will the queries be case-sensitive or not? I thought that it should be based on the database, not on server sorting, but after doing a short test it seems not so. Does anyone know for sure?

Answer 1

Well, I think this explains this:

, . , , . , , , . , GOTO, , , , . , GOTO .

, , , , . , : , /.

Answer 2

, , - ​​ ​​ , . , , db, .

: db , db, , . , . .

?