Interested to Buy Any Domain ? << Click Here >> for more details...
difference between function and procedure
- 3 Answers
- 5503 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
Do you know what are acid properties of transaction?
What is primary key and example?
How to disable stored procedure sql server?
How to modify an existing user defined function?
How to implement service broker?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Do you know what is replace and stuff function in sql server?
What stored by the master? : sql server database administration
What are the advantages of stored procedure in sql server?
What are different types of collation sensitivity?
Define indexes?
How many types of triggers in sql server?
Can I save my report as html, excel or word? : sql server management studio
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
what is a schema in sql server 2005? : Sql server database administration
