What is the difference between Userdefined function and
stored procedure? Explain and give the example also
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 are constraints in microsoft sql server?
What are differences in between sql server 2012 and sql server 2016?
How to test odbc dsn connection settings?
What should be the fill factor for indexes created on tables? : sql server database administration
how you can move data or databases between servers and databases in sql server? : Sql server administration
What are different types of collation sensitivity?
How real and float literal values are rounded?
Do you know how to store and query spatial data?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is the difference between mysql and mysqli?
How to return the second 5 rows in ms sql server?
What do you understand by integration services in sql server?
What are cascading parameters in ssrs reports?
What are ddl (data definition language) statements for tables in ms sql server?
What is inner join? Explain with an example?