Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

---

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---

what do you understand by change data capture?

0 Answers  

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

---

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

what information is maintained within the msdb database? : Sql server administration

0 Answers  

---

What is self contained scalar sub query?

0 Answers  

---

how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.

1 Answers  

---

What do you understand by a stored procedure?

0 Answers  

---

Explain microsoft sql server functions?

0 Answers  

---

What are transactions and its controls?

0 Answers  

---