Answer Posted / talent pool

NULL Is An Unknown Value
So We Couldn't Compare it With Other One.This Is Pure
Correct Answer.

declare @d int
Set @d =null
declare @r int
Set @r=null
if @d=@r
Print 'Hi'
Else
Print 'Summa Vilayadatha'

What is a join?

1069

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1004

---

what is unique key constraint? : Sql dba

1036

---

how to select unique records from a table? : Sql dba

1113

---

List the various privileges that a user can grant to another user?

1043

---

What is cursor explain with example?

987

---

what are all the different types of indexes? : Sql dba

1048

---

What is the non-clustered index in sql?

1064

---

What are the 3 modes of parameter?

1154

---

What are system versioned tables?

1028

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

990

---

What is data types in sql?

1008

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2113

---

How many joins can you have in sql?

938

---

What is the difference between clustered and non-clustered index in sql?

1016

---