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/

Why do we need pl sql?

977

---

What is a primary key? Explain

974

---

How many types of sql are there?

986

---

How do you concatenate in sql?

1027

---

what are the security recommendations while using mysql? : Sql dba

1118

---

Describe different types of general function used in sql?

1038

---

How do you modify a trigger?

926

---

What is int identity in sql?

1141

---

Is sql a programming?

972

---

What is embedded sql with example?

1050

---

Why primary key is required?

1006

---

What is rename in sql?

973

---

Why is %isopen always false for an implicit cursor?

1106

---

How to assign sql query results to pl sql variables?

1079

---

How many primary keys can a table have?

1009

---