SQL Query in C# Program [duplicate]

Question

Is it possible to make an where var1!=var2 ? because when I try the compiler said it"s an invalid operator . (i also tried NOT IS).

The full Error-Message:

Invalid use of '.', '!', or '()'. in query expression
        'emp_course.e_id!=employee.e_id'

What database product? oracle? Please include that SQL statement in your post. — KV Prajapati
– KV Prajapati, Commented Aug 1, 2012 at 8:28
the sql with full explanation is here: stackoverflow.com/questions/11755676/sql-query-in-c-sharp — Meilenea
– Meilenea, Commented Aug 1, 2012 at 8:51

mdm · Accepted Answer · 2012-08-01 08:24:41Z

6

Have you tried this:

where var1 <> var2

TSQL allows both != and <>, whereas other dialects have different rules.

answered Aug 1, 2012 at 8:24

mdm

12.7k5 gold badges36 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

yeah I also tried this this will not throw an error but it seams not to work ... maybe i have a mess in the other part of my sql query ...

Possibly - if you are having trouble with it create a new question and post the link in the comments here, and I'll have a look :)

thanks so much :) i just have to wait another 14min to post it because i'm a newbie here ;)

aikixd · Accepted Answer · 2012-08-01 08:26:18Z

0

As the MSDN sais it should be expression < > expression

answered Aug 1, 2012 at 8:26

aikixd

5145 silver badges16 bronze badges