Thursday, February 12, 2015

IS versus = and IS NOT versus <>

It's hard to tell which is best in SQL sometimes. If you want to check to see if a sproc exists before deleting it as in the reverse of this scenario it is best to use IS NOT, but clearly I get away with not using IS NOT here which I could not do when I attempted the other way (less than followed by greater than) in the first situation. Whatever.

No comments:

Post a Comment