Edvards Veļa
Reputation: 41
is there any difference between: "not variable is null" and "variable is not null"?
I'm a newbie in SQL and I'm wondering if there is any difference between:
not variable is null
and
variable is not null
Upvotes: 3
Views: 88
Answers (1)
Vikrant
Reputation: 5036
Practically there is NO Difference in both terms. Both of them refers to Nullability of the Variable.
If there is any difference then it's simplicity in the reading.
Upvotes: 2
Related Questions
- SQL Server: Null VS Empty String
- How is NOT(IS NULL) different from IS NOT NULL in SQL?
- Is there any difference between IS NULL and =NULL
- what's the difference between is not null and <>' '
- ISNULL vs IS NULL in SQL Server
- sql server difference between a blank column and column with value = 'NULL'
- Difference between NULL in SQL and null in programming languages
- NULL vs empty string
- What is the difference between "Is Not Null" and "Not Is Null"
- When is `x IS NOT NULL` not the same as `NOT(x IS NULL)`