You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

What is a job?

3 Answers  

---

Explain candidate key, alternate key, and composite key?

0 Answers  

---

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

0 Answers  

---

what is a deadlock? : Sql server database administration

0 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

Where cross join is used?

0 Answers  

---

What is the xml datatype?

0 Answers  

---