Difference - @var is null , @var = null

Question

can any one explain difference between @var is null , @var = null

Answer 1

Read this: SQL is null and = null

---

Please don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question. web: www.ronnierahman.com

Answer 2

in simple way to remind

if you want to set NULL value into variable  use equal sign, while in condition use IS NULL

is that right?

Answer 3

in simple way to remind

if you want to set NULL value into variable  use equal sign, while in condition use IS NULL

is that right?

Yes, what are you trying to do?

---

Please don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question. web: www.ronnierahman.com

Answer 4

I am writing some USP .... you know some times our head been block for some time .... :)