what is the difference between procedure and function.
Answer Posted / hitesh
1.Procedure can call a function but Function cannot call
the function.
2.Procedure may or may not return the value but function
must return a scalar value.
3.Procedure can have any statements and function can have
only select like thing
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a collation in ms sql server?
Explain sub-query?
Write an SQL query to obtain the 2nd highest salary.
Why use view instead of a table?
Do you know the different ddl commands in sql?
How to recreate an existing index in ms sql server?
What is use of except clause?
Define candidate key, alternate key, and composite key.
What is a trigger? Why we need it?
How to perform key word search in tables?
What is right outer join in sql server joins?
What are the dis_advantages of stored procedures, triggers, indexes?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
How to change a login name in ms sql server?
Why transaction is important?