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.

How to list all user names in a database?

0 Answers  

---

What are cursors and when they are useful?

0 Answers  

---

What is a materialized view?

3 Answers  

---

what is call by value & call by reference ?

2 Answers   Cap Gemini,

---

What do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

How to write a query with a right outer join in ms sql server?

0 Answers  

---

What command do we use to rename a db, a table and a column?

0 Answers  

---

How to loop through result set objects using mssql_fetch_array()?

0 Answers  

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

What is difference between temp table and cte?

0 Answers  

---

What is the difference between a view and a stored procedure?

0 Answers  

---

Explain different types of locks in sql server.

0 Answers  

---