how many joins we can write if at all we have n no of tables

5 Answers   Tanla Solutions, TS,

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

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?

0 Answers   Facebook,

---

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,

---

What are transactions and its controls?

0 Answers  

---

---

What is an indexing strategy?

0 Answers  

---

How to create a simple user defined function in ms sql server?

0 Answers  

---

How dts is used to extract, transform and consolidate data?

0 Answers  

---

What is merge replication?

0 Answers  

---

How to use copy and concatenate commands in SQL?

0 Answers   Amdocs,

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

What are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---