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 is procedure explain with program?

548

---

What do you think about pl/sql?

529

---

Is sqlite free?

532

---

Where is all the data on the internet stored?

550

---

What is a heap in sql?

524

---

---

write an sql query to find names of employee start with 'a'? : Sql dba

575

---

Explain the types of joins in sql?

571

---

explain access control lists. : Sql dba

553

---

Can we join tables without foreign key?

520

---

How do you select unique values in sql?

494

---

Write a sql select query that only returns each name only once from a table?

564

---

What is the difference between microsoft sql and mysql?

504

---

How do I edit a stored procedure?

552

---

What is a composite primary key?

581

---

What are its different types of dbms?

535

---