Answer / kumar.t

1. Stored Procedure to return the output parameter.
but function only return single values no output
parameter.

2. Select Clause we cann't use stored procdure. but
fucntion we can use.

3. XMl Clause contain we can use stored procdure. but
function we cann't use.

4. Whenever to execute function at present any error in the
function automatically to exit from the function. but
stored procudure to ignore the error then go to next line.

By
Kumar.T

Answer / samant

1.For user defined function one must have to specify it's
return type while in stored procedure it is not mandatory.

2. u can use function in expression but not stored
procedures

What is normalization and its forms?

4 Answers   Challenger Financial,

---

What is the difference between a view and a stored procedure?

0 Answers  

---

Does a server store data?

0 Answers  

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

Do you know the cursor types?

0 Answers  

---

How to create new databases with "create database" statements?

0 Answers  

---

Define inner join in sql server joins?

0 Answers  

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

Tell me the difference between clustered and non-clustered index?

0 Answers  

---

What it means to be triggered?

0 Answers  

---

What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  

---

Working with TLogs

0 Answers  

---