Answer / Krishna Mohan Bhagat

The architecture of MS SQL Reporting Services consists of four main components: Report Server, Report Model, Report Designer (including RDL files), and Extensions. Report Server stores reports and manages report execution, while Report Model provides a way to encapsulate data structures and relationships for reuse across multiple reports.

What do you understand by check constraint in sql server?

1 Answers  

---

How you can get a list of all the table constraints in a database? : Sql server administration

1 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  

---

how can you move the master database

1 Answers   IBM,

---

what is the maximum size of a row in sql server 2000 and 2005

2 Answers  

---

How do I start sql server agent automatically?

1 Answers  

---

How to insert multiple rows with one insert statement in ms sql server?

1 Answers  

---

What does null mean?

1 Answers  

---

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1 Answers   Facebook,

---

What does it mean to invest in the index?

1 Answers  

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---