What is difference between stored procedure & function?
Answer Posted / somu kattikar
Functions
----------
1) can be used with Select statement
2) Not returning output parameter but returns Table
variables
3) You can join UDF
4) Cannot be used to change server configuration
5) Cannot be used with XML FOR clause
6) Cannot have transaction within function
Stored Procedure
-----------------
1) have to use EXEC or EXECUTE
2) return output parameter
3) can create table but won’t return Table Variables
4) you can not join SP
5) can be used to change server configuration
6) can be used with XML FOR Clause
7) can have transaction within SP
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is scalar user-defined function?
What is openrowset sql server?
What are “lock” hints?
How to find the list of fixed hard drive and free space on server?
Define msdb database?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How do I port a number to sql server?
What do mean by xml datatype?
what is hash nonclustered index
What are the types of table?
What are the different types of upgrades that can be performed in sql server?
What is the standby server?
Explain subquery and state its properties?
What is a primary index?
What is stored procedures?