Interested to Buy Any Domain ? << Click Here >> for more details...
difference between function and procedure
- 3 Answers
- 5336 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
Can you type more than one query in the query editor screen at the same time?
can you instantiate a com object by using t-sql? : Sql server database administration
What are different types of statement?
What are the types of lock supported by ?
What is the use of floor function in sql server?
A trigger can reference objects outside the current database? State true or false.
What new changes are being made in SQL Server?
How will you monitor replication latency in transactional replication? : sql server replication
Explain the phases a transaction has to undergo?
After removing a table from database, what other related objects have to be dropped explicitly?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is sql server programming?
Where is my database stored on the hard disk in ms sql server?
What is bit data type?
How do you create a clustered index?
