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
- 10575 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 linked report?
Mention the differences between local and global temporary tables.
You want to implement the one-to-many relationship while designing tables. How would you do it?
Which database stores information about replication?
Explain the different index configurations a table can have?
Can I work with several databases simultaneously? : sql server management studio
How to create sub reports?
Describe how to use the linked server?
Difference between Sql server reporting services and Crystal reports?
What are the components of sql server service broker?
What is the temp table?
Define left outer join in sql server joins?
How to concatenate two binary strings together?
How to drop existing views from a database in ms sql server?
Write a sql query to display the current date?
