What is conditional split?

0 Answers  

---

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  

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

---

How can you append an identity column to a temporary table?

0 Answers  

---

---

how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,

---

What is for xml in sql server?

0 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

What is the function of sql server agent windows service?

0 Answers  

---

What are the differences between having and where clause.

0 Answers  

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

Do you know clustered and non-clustered index?

0 Answers  

---