I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

which background process will run @ the time of creation of catalog database

1 Answers   CSC,

---

---

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

internal architecture

0 Answers   CSC,

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---