如何在datatable.select中使用Not IN？

本文介绍了如何在datatable.select中使用Not IN？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

如何在datatable.select中使用Not IN？ 请帮助..

How to use Not IN in datatable.select? Pls help ..

推荐答案

尝试 http：//blog.sqlauthority。 com / 2007/05/22 / sql-server-2005-comparison-except-operator-vs-not-in / [ ^ ]

使用字符串它可以工作，但是使用int，guids等你必须使用转换。 检查这个帖子： social.msdn.microsoft/forums/en-US/adodotnetdataproviders/thread/db75a5f8 -af77-4801-8d29-73b13f5928b8 / [ ^ ] With strings it works, but with int, guids etc you have to use a conversion. Check this thread: social.msdn.microsoft/forums/en-US/adodotnetdataproviders/thread/db75a5f8-af77-4801-8d29-73b13f5928b8/[^]

chinnu20写道： chinnu20 wrote:

紧急

有趣的是，对我们来说根本不紧急。如果您需要免费帮助，您必须接受它的速度。你考虑买一本关于SQL的书吗？阅读一些在线文章？如果你真的对这个问题毫无头绪，那么你应该记住，当我写一篇我期待很多的文章时，我输入的回答一个人的内容要远远少于我所做的工作。人们会读。使用这些论坛了解具体问题，使用谷歌和在线文章我无能为力，不能为购买书籍而烦恼。

Funny enough, it's not urgent to us at all. If you want free help, you have to accept the speed at which it comes. Did you consider buying a book on SQL ? Reading some online articles ? If you're really this clueless on the subject, you should keep in mind that what I'd type in to answer one person, is a lot less than the work I'd put in if I was writing an article that I expected many people would read. Use these forums for specific questions, use google and online articles for 'I am clueless and can't be bothered buying a book' questions.