How to write stored procedure to update the data in 10 tables

4 Answers  

---

What is self join in sql server joins?

0 Answers  

---

What are the two modes of authentication in sql server?

0 Answers  

---

Where are stored procedures in sql server?

0 Answers  

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

0 Answers  

---

Is it possible to call a stored procedure within a stored procedure?

0 Answers  

---

When would you use sql joins?

0 Answers  

---

Does group by or order by come first?

0 Answers  

---

What stored procedure can you use to display the current processes?

0 Answers  

---

What does Master database contains?

0 Answers   Abacus,

---