SqlServer 查寻重复的数据（区分大小写）
SqlServer 查找重复的数据（区分大小写）
日文系统中 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)))
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中查找重复的数据（区分大小写）
SELECT * FROM TABLE_NAME WHERE (IKEYWORD COLLATE Chinese_CS_AS_KS_WS IN (SELECT KEYWORD COLLATE Chinese_CS_AS_KS_WS AS Expr1 FROM TABLE_NAMEAS TABLE_NAME_1 GROUP BY KEYWORD COLLATE Chinese_CS_AS_KS_WS HAVING (COUNT(*) > 1)))
1 楼
gteam.yu
2011-04-01
你在查询的时候才区分大小写这样子让不懂的人看起来很头疼啊，所以你应该在建立表的时候就把这些约束条件加进去，不要等查询的时候才用COLLATE。