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.

What is the difference between functions and scalar functions?

0 Answers   EXL,

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 Answers  

---

How do I run sql server 2014?

0 Answers  

---

Which are new data types introduced in sql server 2008?

0 Answers  

---

Tell me about builtinadministrator?

0 Answers  

---

What are the basic functions for master, msdb, model, tempdb databases?

0 Answers  

---

Explain the ways to controlling cursor behavior?

0 Answers  

---

write sql program to get the detail of student in a class?

2 Answers  

---

What is difference between clustered and non clustered index?

0 Answers  

---

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

0 Answers  

---