what is the difference between procedure and function.

Answers were Sorted based on User's Feedback



what is the difference between procedure and function...

Answer / plabana

1.StoreProcedure may return avalue may not return a value
but Function returns the value.
2.SttoreProcedure can be called independently using exec
keyword ,Function are called using select stmt.
3.StoreProcedure can create a table but can't return a table
where as Function can return a value.
4.Transaction related stmt can be handeled by StoreProcedure
Where as it can;t be handeled by Function.

Is This Answer Correct ?    17 Yes 0 No

what is the difference between procedure and function...

Answer / saraswathi muthuraman

Function :

1) Must return a single value. Only one value can be return
from a function.

2) Can be called from a sql(insert,update,delete) or
assignment st.U can't execute the function directly.

3) Can have DML,DDL,TLC inside function. But those function
can not be called from a sql.

Procedure :

1) Procedure can return multiple values.Procedure is
optional to return a value.

2) Can be executed directly and u can't called procedure
from sql.

3)Can have DML,DDL,TLC inside Procedure.

Is This Answer Correct ?    3 Yes 0 No

what is the difference between procedure and function...

Answer / hitesh

1.Procedure can call a function but Function cannot call
the function.
2.Procedure may or may not return the value but function
must return a scalar value.
3.Procedure can have any statements and function can have
only select like thing

Is This Answer Correct ?    0 Yes 0 No

what is the difference between procedure and function...

Answer / saurav kumar

1) Inside Stored procedure we can write functions but
inside function we can't write Stored procedures.

2) Stored proedure may or may not return a value but
function must return a value.

3) Stored Procedures can be called independently using exec
keyword ,Function are called using select statement.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Differentiate between truncate vs delete in mssql?

0 Answers  


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

1 Answers  


explain different types of jions with examples briefly?

3 Answers   Zensar,


what is web server?

3 Answers   Satyam,


What is resource governor in sql server?

0 Answers  






How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?

1 Answers   GE,


Explain what is analysis service repository?

0 Answers  


If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

0 Answers  


Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  


Are semicolons required at the end of sql statements in sql server 2005?

0 Answers  


You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  


Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,


Categories