Can sql servers linked to other servers like oracle?

0 Answers  

---

Please differentiate between a local and a global temporary table?

0 Answers  

---

What is the order by used for?

0 Answers  

---

Why are views required in the sql server or in any other database?

0 Answers  

---

What is difference between standardization and normalization?

0 Answers  

---

What is model database in sql server?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

How you can get a list of all the table constraints in a database?

0 Answers  

---

Which is faster statement or preparedstatement?

0 Answers  

---

what is a schema in sql server 2005? : Sql server database administration

0 Answers  

---

System variable and temporary variables

0 Answers   Wipro,

---

Do you know what is openxml in sql server?

0 Answers  

---