Answer Posted / gaurav arora

The answer-6 is quite matching with my stuff. Let me clear
it in more writting:
1. When we compare two nulls then the result
always 'false'. The main reason is the null is not a value
its neither an empty nor a empty space, so the actual
result is null which places as null.
2. When we compare a null with another which has some value
like some int value then the result is false. The actual
result is false and not null.

Consider the following examples:

--null = null is null which is false
Declare @intNull1 int
Set @intNull1 =null
Declare @intNull2 int
Set @intNull2=null
If @intNull1=@intNull2
Print 'null = null is true'
Else
Print 'null = null is false'

--Now assign some value
Set @intNull1 = 1
If @intNull1=@intNull2
Print 'null = int value is true'
Else
Print 'null = int value is false'

Thanks,
Gaurav Arora
http://stuff4mdesktop.blogspot.com/

How many sectors are in a partition?

1072

---

How to raise user-defined exception with custom sqlerrm ?

1121

---

Why primary key is required?

998

---

Can we use distinct and group by together?

1047

---

What is multiple columns?

1060

---

What is difference between sql and excel?

1082

---

How do I view a sql trace file?

1019

---

How sql query is executed?

1125

---

what is the difference between delete and truncate commands? : Sql dba

1061

---

What are the advantages of normalization?

1074

---

When is the explicit cursor used ?

1028

---

How can you fetch first 5 characters of the string?

1009

---

What is the use of pl/sql table?

1058

---

Does truncate free space?

1003

---

What is the non-clustered index in sql?

1056

---