About Indexed Views? with example? plz reply...

2 Answers  

---

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

---

How to skip remaining statements in a loop block using continue statements?

0 Answers  

---

What is set nocount on?

0 Answers  

---

How efficient you are in oracle and SQL server?

0 Answers   CGI,

---

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

How to start and end transact-sql statements?

0 Answers  

---

What is lock escalation and what is its purpose?

0 Answers  

---

can you any body tell me which service pack is installed in the sql server?

3 Answers  

---

What is a transact-sql statement?

0 Answers  

---

How you can find out if an index is useful to the optimizer?

0 Answers  

---