Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

what is Covering Index ?

3 Answers   Thomson Reuters,

---

Can an entity have two primary keys?

0 Answers  

---

What are the transaction properties?

0 Answers  

---

How can you check the version of sql server?

0 Answers  

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

What does truncate do?

0 Answers  

---

What is difference between joins and subqueries?

0 Answers  

---

What is temporary stored procedure?

0 Answers  

---

What is t-sql script to take database offline – take database online.

0 Answers  

---