How to link tables in sql server?

0 Answers  

---

What happens when transaction log is full?

0 Answers  

---

What is indexed view? How to create it?

0 Answers  

---

Mention the command used to rename the database.

0 Answers  

---

How do I trace a query in sql server?

0 Answers  

---

---

What are the recovery models for a database?

0 Answers  

---

What are subqueries in sql server? Explain its properties.

0 Answers  

---

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

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,

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

---

What is primary key index?

0 Answers  

---