Answer / Ali Murtaza

To create an index in SQL Server 2005, you can use the CREATE INDEX statement. For example: CREATE INDEX idx_name ON table_name (column_name ASC/DESC).

What is stored procedures?

1 Answers  

---

Can you explain what is indexed view? How to create it?

1 Answers  

---

Where are magic tables stored ? Is it in the same database where it is created ?

4 Answers  

---

Explain difference between control flow and data flow?

1 Answers  

---

What are subqueries in sql server? Explain its properties.

1 Answers  

---

What is the use of SCOPE_IDENTITY() function?

2 Answers  

---

role of sql sever 2005 in database rather than any other database

1 Answers  

---

Explain ranking functions?

1 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

What is the difference between ddl,dml and dcl commands?

1 Answers   BirlaSoft, Verifone,

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1 Answers  

---