Answer Posted / sunil

HI ALL

IN CASE OF INSERTING REPETED NULL IN UNIQUE KEY COLOUMN ,
IF IT IS COMPOSITE KEY IS POSSIBLE. . . ANY LOGICAL RESON?

Eg:
CREATE TABLE TRY(ROLL NUMBER,LIB_CARD_NO NUMBER,
CONSTRAINT CON_UNQ UNIQUE(ROLL,LIB_CARD_NO));

INSERT INTO TRY VALUES(NULL,NULL);
--> 1 ROW CREATED
INSERT INTO TRY VALUES(NULL,NULL);
--> 1 ROW CREATED -- REPETED NULL ARE ALLOWED!!!!

Explain features and concepts of analysis services?

1022

---

What is difference between cte and view?

975

---

What is the difference between grant and with grant while giving permissions to the user?

1025

---

Can a unique index be created on a column, which contains null?

968

---

What is function of ROLLUP ?

1139

---

What are the characteristics of modern DBMS?

1140

---

What is the recursive stored procedure in sql server?

1076

---

What is the difference between char, varchar and nvarchar?

1076

---

What is the osql utility?

1036

---

What are the advantages dts has over bcp?

1050

---

How can you know if the row fetched from cursor is still valid in underlying table?

1044

---

What are the types of subscriptions in SQL Server replication?

1104

---

How many types of triggers in sql server?

1089

---

What is meant by indexing?

1083

---

How to encrypt data between dialogs?

1167

---