1. Print statement is not valid within the function because functions are meant for process or execute group of statement and return a value, where as procedure are meant for executing group of statement and display output.
2. Return keyword is use to return a value from a stored function with specified data type of the value expecting to be returned from stored function.
3. One of the major advantage of stored function is that can be used in the query directly where as an stored procedure can never be used in a query as it is not returning any value.
Post a Comment