Answer / guest

Linked Servers is a concept in SQL Server by which we can
add other SQL Server to a Group and query both the SQL
Server dbs using T-SQL Statements.

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   CarrizalSoft Technologies, HCL,

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

How to delete a database in ms sql server?

0 Answers  

---

How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,

---

Is there any difference between the primary key and unique key?

0 Answers  

---

---

How to use linked server?

0 Answers  

---

What is trigger ?

7 Answers   Cap Gemini, SQL,

---

After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

---

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

---

Introduction of rollup clause using sum and group by clause?

0 Answers  

---

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 the difference between rank and dense_rank?

0 Answers  

---