What is cross join in sql server joins?

0 Answers  

---

What are different types of constraints?

0 Answers  

---

Explain couple pf features of SQL server

2 Answers  

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

0 Answers  

---

what are the limitations of parameters in a storedprocedure

1 Answers  

---

Where are sql server user names and passwords stored in sql server?

0 Answers  

---

What is normalization according to you and explain its different levels?

0 Answers  

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

What is a job?

3 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What are the system database in sql server 2005?

0 Answers  

---

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,

---