Difference between writing SQL query and stored procedure ?

15 Answers   Cognizant, Infosys, TCS, Veritas,

---

How to drop an existing table with "drop table" statements in ms sql server?

0 Answers  

---

What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

---

What is the process of normalising?

0 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 BCP? When do we use it?

2 Answers  

---

What are the different types of columns types constraints in the sql server?

0 Answers  

---

Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,

---

Explain the different types of joins?

0 Answers  

---

What are views in ms sql server?

0 Answers  

---

How do I trace a query in sql server?

0 Answers  

---

Explain stored procedure?

0 Answers  

---