以下是我使用的查询语句,直接在VS.NET 2008的服务器资源管理器中查找数据,查找的结果是NULL,这应该和项目ENCODING没关系了。SELECT MesID, Title, Description, AddedDate, AddedBy, adminContent, IsView,
Moderated
FROM per_MesBoard
WHERE (AddedBy = N'长江一号')SELECT MesID, Title, Description, AddedDate, AddedBy, adminContent, IsView,
Moderated
FROM per_MesBoard
WHERE (AddedBy LIKE ' %长江一号%')
两种方法都查不到值,如果是获取ID字段才能查询到。请问怎么处理呢?
Moderated
FROM per_MesBoard
WHERE (AddedBy = N'长江一号')SELECT MesID, Title, Description, AddedDate, AddedBy, adminContent, IsView,
Moderated
FROM per_MesBoard
WHERE (AddedBy LIKE ' %长江一号%')
两种方法都查不到值,如果是获取ID字段才能查询到。请问怎么处理呢?
Moderated
FROM per_MesBoard
WHERE (AddedBy LIKE N'%长江一号%')在SQL查询分析器执行一下此句,看结果如何
这个是我查找所有的结果:
SELECT MesID, Title, Description, AddedDate, AddedBy, adminContent, IsView,
Moderated
FROM per_MesBoard
WHERE (AddedBy LIKE ' %长江一号%') ' %长江一号%'中“%长江”前面多了个空格,就找不到了,这个请各位也注意下!
非常感谢htl258和xys_777的热心帮助!!