What is difference between view and materialized view?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

how to get the automatic backup of the database in the sql server

4 Answers  

---

What is key attribute?

0 Answers  

---

i want table name basis on column name.

5 Answers  

---

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

How many primary keys are possible in a table?

0 Answers  

---

Explain what are sparse columns?

0 Answers  

---

What is the use of @@spid?

0 Answers  

---

Why is normalisation important?

0 Answers  

---

Does group by sort data?

0 Answers  

---

What do you mean by collation recursive stored procedure?

0 Answers  

---