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 default constraint?

1001

---

When do you think a developer should use sql server-based cursors?

1052

---

Tell me what is the significance of null value and why should we avoid permitting null values?

990

---

Can you create a logon trigger in sql server 2005 express edition?

1084

---

ow to bring suspect mode datbase online from scratch

1807

---

How do I setup a local sql server database?

1010

---

What is sql collation?

1215

---

how can u get last observation in an unknown dataset ?

2436

---

Where the sql logs gets stored? : sql server database administration

970

---

What is a trace frag? Where do we use it?

1100

---

What is analysis service repository?

1025

---

Explain an incremental backup?

1007

---

what is nonclustered index

962

---

Can sql servers link to other servers?

1093

---

Why does sql studio use a single registered database repository? : sql server management studio

1004

---