What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

How to delete duplicate rows from table except one?

0 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

What is sql server programming?

0 Answers  

---

---

How do I make a resultset scrollable?

0 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

Explain about analysis services?

0 Answers  

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

0 Answers  

---

How many types of stored procedures are there in sql server?

0 Answers  

---

Can group by be used without aggregate functions?

0 Answers  

---

Explain view in sql server?

0 Answers  

---