What is the difference between Userdefined function and
stored procedure? Explain and give the example also
Answers were Sorted based on User's Feedback
1.A stored procedure is a precompiled collection of
Transact-SQL statements stored under a name and processed
as a unit that you can call from within another Transact-
SQL statement or from the client applications.
2.Stored procedure performs an action.
3.A collection of SQL statements often combined with
Control-of-flow statements.
1.User Defined Functions are compact pieces of Transact SQL
code, which can accept parameters, and return either a
value, or a table. They are saved as individual work units,
and are created using standard SQL commands. Data
transformation and reference value retrieval are common
uses for functions.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / ashwini
1. User defined functions can be used in select statements.
Procedures can not be used.
2. Functions must return some value. Procedures do not
always return the value.
3. Functions will take only input parameters. Procedures
can take input as well as output parameters.
4. Not all types of user-defined functions use
INSERT,UPDATE,DELETE statements(Only multi-statement table
valued functions can use). All procedures can use these
statements.
Is This Answer Correct ? | 6 Yes | 2 No |
1. function always run with select command while stored
procedure execute with execute command
2. function not provide output parameter facility
while stored procedure provide output facility
3. function always execute means it execute more than one
time while store procedure execute only one time
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ashish
Please check out the below link. I think it may be useful:
http://newtechnobuzzz.blogspot.in/2014/07/difference-between-user-defined-funtion.html
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anil sharma
Userdefined function can used in select statement.
It must return a values but in store procedure it is
optional.
Store procedure can use using sqlparameter but in
userdefined function it is not used.
Is This Answer Correct ? | 1 Yes | 2 No |
What are trace flags?
What is the difference between ddl,dml and dcl commands?
0 Answers BirlaSoft, Verifone,
Explain DBCC?
What is the datatype of rowid?
Explain what role entity and relationship play in an ER diagram.
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
How to select Distinct columns from the table, table having 20 columns and i want all coulmns
How to set database to be read_only in ms sql server?
how to improve the speed of SQL database server and how to avoid dead lock?
What is difference in performance between insert top (n) into table and using top with insert?
What is read committed?
What is 2nf normalization form?