Answer / srinivas k

Function should always return a value, where as Store Proc
may or may not return values.
Functions can be part of DML statements, where SP cannot be.
SP are precompiled and functions are not.

Answer / sakthi

Inside function we cannot able to insert, udate or delete
any record but in procedure we can use it. inside function
we cannot able to call any other functions or procedure but
inside procedure we can call other procedure and functions.
these are the major differences

Answer / pradeep aryan

1. Function can returtn single value but proc san return
multiple values

2. Proc can call a function but function not.

3. function can call in select statement also and acn perform
action also but proc not.

Answer / jayanth

Functions always returns a value where as sp performs bath execution
functions can be used along with select statement and where clause where as functions cannot be used with update insert delete statements in which sp cannot be used with select and DML events
functions cannot be used with try catch block where as sp can use try catch block
functions are of two types system functions and user defined functions where as sp's are four types mostly
sp with parameters
sp without parameters
sp with out parameters
sp with return values

Answer / rakesh

function always return value, and procedure not Return the value.

What is correlated subquery in sql server?

0 Answers  

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

Tell me what is use of except clause? How it differs from not in clause?

0 Answers  

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

0 Answers  

What is difference between drop truncate and delete?

0 Answers  

What is the sql case statement used for? Explain with an example?

0 Answers  

What is the difference between temp table and table variable?

8 Answers   Microsoft,

Explain different types of lock modes in sql server 2000?

0 Answers  

Create and insert into temp table in sql server?

0 Answers  

How is a full-text index updated?

0 Answers  

What is the use of MOVE keyword in restore command

3 Answers   IBM,