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')

How to select all columns of all rows from a table with a select statement in ms sql server?

1118

---

How to add a new dsn with the odbc driver for sql server?

1062

---

What is code near application topology?

279

---

How to list all tables in the database using odbc_tables()?

1052

---

Explain about Views?

1072

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

982

---

How to add additional conditions in SQL?

1025

---

What is a virtual table in sql?

1000

---

What is left outer join in sql server joins?

1045

---

Explain can you implement data mining in ssrs?

159

---

How to specify the collation for a character data type in ms sql server?

1031

---

last function used in MS Access to convert sql what function will use in sql

2077

---

What security features are available for stored procedure?

1036

---

Describe in brief databases and sql server databases architecture.

1014

---

what are the critical issues you have resloved in your company

1964

---