SQL Query that changes the collation in the where clause. - Cacher Snippet

7/6/2015 - 7:47 PM

SQL Query that changes the collation in the where clause.

SQL Query that changes the collation in the where clause.

SQL Collation Where.sql

SELECT TOP 5000 * FROM CST_ITEM_COSTS cic
WHERE cic.ROWIDChar = 'AADSaGAAfAABr6ZAAB' COLLATE SQL_Latin1_General_CP1_CS_AS
ORDER BY cic.SSIS_DateTime DESC
--WHERE cic.ROWID = 2513733815