I wish to perform a case sensitive query on an SQL Server table.
I have found an example :
Select * from a_table where attribute = 'k' COLLATE Latin1_General_CS_AS
Can I be assured that executing this query will not affectsubsequent queries that don't have the COLLATE statement ?
In other words, the default COLLATION for the table will not be affected ?