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
- 10764 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
Difference between Logical Page and Physical Page in SSRS.
Will the writetext statement activate a trigger?
Explain transaction server distributed transaction?
What is the function of inner join?
How to start sql server browser service?
What are the dis_advantages of stored procedures, triggers, indexes?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
How we can compare two database data?
What protocol does sql server use?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is indexing explain it with an example?
What do you mean by an execution plan? Why is it used?
Which tcl commands are available on the sql server?
Delete duplicate rows without using rowid.
