What is an entity-relationship diagram (erd)?

0 Answers  

---

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

What is a self join in sql server?

0 Answers  

---

write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

---

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---

How to Debug a Stored Procedure?

5 Answers   Allianz,

---

What is a deadlock and what is a live lock?

0 Answers  

---

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

Can we create clustered index on composite key?

0 Answers  

---