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,

---

Define inner join in sql server joins?

0 Answers  

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

what is the order of execution of where,having,group by in select stement

6 Answers   IBM, Tanla Solutions,

---

What is a db view?

0 Answers  

---

What are diverse clauses that form a part of sql?

0 Answers  

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

Do you know what are acid properties?

0 Answers  

---

Do you know what are the properties of the relational tables?

0 Answers  

---

Write a SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---