Answer Posted / rammohan176

yes Unique constraint accept more than one null.... because null is always not equal to another null value.i.e null<>null.
if any body have doubt please check this
CREATE TABLE TEST1 ( ENO NUMBER CONSTRAINT EU UNIQUE,
NAME1 VARCHAR2(10))

INSERT INTO TEST1 (NAME1) VALUES('RAM')

INSERT INTO TEST1 (NAME1) VALUES('KARTHIK')
INSERT INTO TEST1 (NAME1) VALUES('SANTHOSH')
INSERT INTO TEST1 (NAME1) VALUES('SANDY')

What are sql azure firewall rules?

106

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1902

---

Explain the functionalities that views support?

1046

---

What is store procedure? When do you use?

873

---

what is checksum in sql server.........???

1623

---

How to add additional conditions in SQL?

974

---

Explain transaction isolation levels in sql server?

1038

---

State a few properties of relational databases?

1062

---

How can I check that whether automatic statistic update is enabled or not?

987

---

What is the maximum size of column in sql server?

850

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1695

---

Tell me what is difference between view and materialized view?

887

---

Why the trigger fires multiple times in single login?

1155

---

Explain what is analysis service repository?

928

---

How to remove duplicate rows from table?

1165

---