What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

What are the types of normalization?

0 Answers  

---

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

---

What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,

---

Do you have any idea about the tcl commands?

0 Answers  

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

What is set nocount on and what is set nocount off?

0 Answers  

---

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

---

How to end a stored procedure properly in ms sql server?

0 Answers  

---

Which is faster statement or preparedstatement?

0 Answers  

---

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,

---

What is join query?

0 Answers  

---