Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

---

What is SQL server agent?

2 Answers   HCL, SAP Labs,

---

What is the difference between dataadapter and datareader?

0 Answers  

---

---

What is a unique index?

0 Answers  

---

How to create a dynamic cursor with the dynamic option?

0 Answers  

---

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

What is an example of a primary key?

0 Answers  

---

What is analysis service repository?

0 Answers  

---

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

---

What are the types of sql server?

0 Answers  

---