difference between function and procedure
- 3 Answers
- 4233 Views
- Cognizant, HCL, TCS, Theorem, I also Faced
- E-Mail Answers
Answer Posted / ramya gurrala
Functions:1)Do calculations mostly.
2)Must return value.
3)Calling methods.
4)Function can stand alone.
Procedure:1)Do actions mostly.
2)May or may not return value(the return method is not same as function method).
3)Calling methods.
4)Procedure can not stand alone.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to encrypt data between dialogs?
What is a group function explain with an example?
What are the properties of primary key?
Explain what is scheduled job and how to create it?
Which joins are sql server default?
Why should we go for stored procedures? Why not direct queries?
What is a full text index?
What is 'write-ahead log' in sql server 2000 ?
can an order by clause be used in a creation of a view?
What is default port number for sql server 2000?
How to create an index on a view?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is side by side migration in sql server?
How to return the top 5 rows from a select query in ms sql server?
Delete duplicate rows without using rowid.
