Answer Posted / manoj pandey

No this is not possible... columns with Unique constraint
can only contain 1 null value/row.

@Manish... could you please try this:

create table #tempTable (id int, name varchar(50) unique)

insert into #tempTable
select 1, 'manoj' union
select 2, null union
select 3, null union
select 4, 'pandey'

Explain the truncate command?

990

---

What is row_number function?

1015

---

What is the osql utility?

978

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1808

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

1048

---

What are a scheduled jobs?

956

---

what are isolation levels? : Sql server database administration

1000

---

How do you size a resultset?

920

---

Explain error handling in ssis?

1034

---

What is the architecture of ms sql reporting service?

988

---

What are views used for?

1020

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

945

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1078

---

What is nested transaction?

1106

---

What is normalization according to you and explain its different levels?

957

---