tom preston tom preston - 1 year ago 75
SQL Question

Exclamation mark in table.column !=0

Using SQL Server 2008 I have a query which resembles this:

FROM myTable mt
left join otherTable ot on mt.ID = ot.ID
WHERE DateTime > '20160801'
and mt.ID !=0

What is the
? It looks like it's the same as saying
<> 0

I am unable to google this, is this in fact the same? A link to some documentation would be appreciated.

Thanks in advance, TP

Answer Source

It is exactly the same operator as <>.

See MSDN for reference.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download