Answer Posted / deepak

1)Functions cannot affect the state of the database which
means we cannot perform insert,delete,update and create
operations on the database.
Stored Procedures can affect the state of the database by
using insert,delete,update and create operations.

2)Functions are basically used to compute values
stored procedures are basically used to process the task.

what's sql server? : Sql server database administration

928

---

How to receive output values from stored procedures?

1053

---

How do I make a resultset scrollable?

908

---

Can group functions be mixed with non-group selection fields in ms sql server?

888

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

960

---

What is a coalesce function?

1127

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

836

---

Differentiate between a primary key and a unique key.

998

---

List some case manipulation functions in sql?

965

---

What is an sql server agent?

994

---

what is the different types of backups available in sql server? : Sql server database administration

879

---

what is the system function to get the current user's user id? : Sql server database administration

952

---

Is natural join and equi join same?

910

---

Which language is supported by sql server?

953

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

899

---