Answer / pravin

It is not possible to compare two nulls with each other.
Still if we want to compare null then we have isnull
operator.

Answer / 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/

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

---

Explain cursor types?

0 Answers  

---

What is a heap in sql?

0 Answers  

---

write the Sql query for creating database backup?

7 Answers   TCS,

---

What are procedures used for?

0 Answers  

---

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

---

Does truncate require commit?

0 Answers  

---

i have some prob lem to tell me about my self in interview first round ...

0 Answers  

---

Which are the most commonly used sql joins?

1 Answers  

---

what are the features and advantages of object-oriented programming? : Sql dba

0 Answers  

---

how to install mysql? : Sql dba

0 Answers  

---

How do I run pl sql in sql developer?

0 Answers  

---