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!!!!

What is for xml in sql server?

973

---

Explain the difference between delete,drop and truncate in SQL Server?

1014

---

How to check table values in sql server?

908

---

What objects does the fn_my_permissions function reports on? : sql server security

990

---

How sql server executes a statement with nested subqueries?

955

---

What is check constraint in sql server?

946

---

Can we insert data into view sql server?

882

---

When you use @@error and try-catch?

979

---

What the different components in replication and what is their use?

912

---

what is create database syntax? : Sql server database administration

1043

---

What is lock escalation? : sql server database administration

1101

---

what are the disadvantages of cursors? : Sql server database administration

969

---

What the class forname () does?

969

---

How to create new databases with "create database" statements?

957

---

Do you know what are the reporting services components?

915

---