日文系统中 sqlserver中查找重复的数据（区分大小写）

写道SELECT * FROM TABLE_NAME
WHERE (IKEYWORD COLLATE Japanese_CS_AS_KS_WS IN
(SELECT KEYWORD COLLATE Japanese_CS_AS_KS_WS AS Expr1
FROM TABLE_NAMEAS TABLE_NAME_1
GROUP BY KEYWORD COLLATE Japanese_CS_AS_KS_WS
HAVING (COUNT(*) > 1)))

中文系统中 sqlserver中查找重复的数据（区分大小写）

Sql代码

1. SELECT * FROM TABLE_NAME
2. WHERE (IKEYWORD COLLATE Chinese_CS_AS_KS_WS IN
3. (SELECT KEYWORD COLLATE Chinese_CS_AS_KS_WS AS Expr1
4. FROM TABLE_NAMEAS TABLE_NAME_1
5. GROUP BY KEYWORD COLLATE Chinese_CS_AS_KS_WS
6. HAVING (COUNT(*) > 1)))

方正飞鸿：http://www.founderfix.com