Answer Posted / khurram

1>Procedure can return zero or n values whereas function can
return one value which is mandatory.

2>Procedures can have input,output parameters for it whereas
functions can have only input parameters.

3>Procedure allow select as well as DML statement in it
whereas function allow only select statement in it.

4>Functions can be called from procedure whereas procedures
cannot be called from function.

5>Exception can be handled by try-catch block in a procedure
whereas try-catch block cannot be used in a function.

6>We can go for transaction management in procedure whereas
we can't go in function.

7>Procedures cannot be utilized in a select statement
whereas function can be embedded in a select statement.

How to define and use table alias names in ms sql server?

1103

---

What are relationships and mention different types of relationships in the dbms

946

---

Explain about Joins?

969

---

What is 2nf in normalization?

972

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1031

---

Is the primary key column of a table an index in ms sql server?

946

---

How to copy data from one table to another table?

982

---

What is meant by indexing?

996

---

What are parameterized reports?

198

---

Differentiate sql server reporting services vs. Crystal reports?

200

---

Explain how to send email from sql database?

1025

---

Can We Use Data-grids For Our Report In Ssrs?

184

---

What is relationship? What number of sorts of relationship are there?

1109

---

If a table does not have a unique index, can a cursor be opened on it?

898

---

What is a trace frag?

1063

---