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
- 10597 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 form?
What is truncate table?
Define model database?
What are the different ways you can create databases in sql server?
What is meant by indexing files?
How to delete duplicate records based on single column from a table?
What are the properties of the transactions?
what is create database syntax? : Sql server database administration
what is the maximum size of a row? : Sql server database administration
What is indexing a document?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
List out the different types of locks available in sql server?
How each E-R model constructs can be mapped to the relational model?
How to drop an existing table with "drop table" statements in ms sql server?
How to set database to be single_user in ms sql server?
