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/

What are sql objects?

1067

---

Why schema is used in sql?

1032

---

Why use stored procedures?

1066

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

997

---

how many columns can be used for creating index? : Sql dba

932

---

What are the various levels of constraints?

1117

---

Is sql better than excel?

1122

---

Can variables be used in sql statements?

1020

---

What is package in pl sql?

1003

---

Are subqueries better than joins?

959

---

how to extract a unit value from a date and time? : Sql dba

981

---

How can we make an if statement within a select statement?

1000

---

Why are indexes and views important to an organization?

939

---

How many types of index are there?

1021

---

how many ways we can we find the current date using mysql? : Sql dba

1081

---