Answer / monal

using linked server or using openrowset command.

Answer / hemendra

using external table

Can a table have 2 foreign keys?

0 Answers  

---

What do you mean by an execution plan?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

1 Answers  

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

Explain how to maintain a fill factor in existing indexes?

0 Answers  

---

How to find the last update record in SQL Server?

4 Answers  

---

What are Magic Table?

34 Answers   3i Infotech, Digiweb, Evalueserve, NIIT, PL,

---

How to execute the cursor queries with "open" statements?

0 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

What is inner join in sql server joins?

0 Answers  

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

0 Answers  

---

How to provide login information for a new odbc dsn?

0 Answers  

---