如何在SQL 2000/2005中执行区分大小写的搜索和替换？

SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE = 'VARCHAR' AND CHARACTER_MAXIMUM_LENGTH = 255;

USE MASTER; -- 设定当前数据库为 MASTER，因为在其他数据库中，区分大小写的搜索和替换将仅适用于当前数据库
GO
-- 假设要搜索的产品名称为 PRODUCTION_1
SELECT *
FROM Production
WHERE ProductName LIKE 'PRODUCTION\_1';

GO
-- 使用 COLLATE 声明以区分大小写
SELECT *
FROM Production
WHERE ProductName LIKE 'PRODUCTION_1 COLLATE SQL_Latin1_General_CI_AS';

SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE = 'VARCHAR' AND DEFAULT_ON_UPDATE_ATAL = 'YES';

WITH Lowercases AS (
SELECT LOWER(ProductName) AS LowerCaseProduct
FROM Production
)
SELECT *
FROM Lowercases
WHERE LowerCaseProduct LIKE 'PRODUCTION\_1 COLLATE SQL_Latin1_General_CI_AS';