Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Userdefined function and
stored procedure? Explain and give the example also
- 5 Answers
- 10362 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is 3nf normalization?
How to get a list of columns in a view using the "sp_columns" stored procedure?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
If no size is defined while creating the database, what size will the database have?
Tell me the difference between clustered and non-clustered index?
What is query optimization process?
What is federation member?
How to insert stored procedure result into temporary table?
What is implicit mode in sql server?
How to deploy the Report?
What happens when unicode strings concatenate with non-unicode strings?
How to enforce security in sql server? : sql server security
What is xdr?
What is stored procedures?
What is role playing dimension with two examples? : sql server analysis services, ssas
