Answer / vinod

By Using linked server we can get data from remote servers, and we can fire a query on remote server. we need to use three part naming conventions for this.

servername.databasename.dbo.tablename

Answer / guest

Use the OpenRowSet Function to Run a Query on a Remote SQL
Server.

Explain the etl (extraction, transformation, and loading)?

1 Answers  

---

Different Types of Functions ?

2 Answers   Satyam,

---

What does <> symbol mean?

1 Answers  

---

What is an indexed view?

0 Answers  

---

How to update muliple row in single query?

1 Answers   MCN Solutions,

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---

What is intellisense?

1 Answers  

---

what is normalization? what is denormalization?

9 Answers   Satyam,

---

How would we use distinct statement? What is its use?

1 Answers  

---

syntax and example for bitmap index in sql???

1 Answers  

---

Can we insert data if clustered index is disabled?

1 Answers  

---

What is the need for group functions in sql?

1 Answers  

---