Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   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  

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

How to get the definition of a view out of the sql server?

0 Answers  

---

Can primary key be a foreign key?

0 Answers  

---

How can i Relate Tables in SSIS

0 Answers   HCL,

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

Explain what is cte (common table expression)?

0 Answers  

---

How to create an multi-statement table-valued function?

0 Answers  

---

How to trouble shoot if unable to connect SQL Server

0 Answers  

---

What are ddl triggers and types of ddl trigger?

0 Answers  

---