difference between function and procedure
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
What are security principals used in sql server 2005?
tell me the disaster recovery plan
What is rolap and its advantage? : sql server analysis services, ssas
What is #table in sql server?
Define Wed Edition in SQL Azure?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain triggers in sql?
What are the purpose of Normalisation?
What is RMS migrations?
Does a full backup include transaction log?
How do I manually uninstall an instance of sql server 2016?
Explain in brief how sql server enhances scalability of the database system?
Explain the third normal form(3nf)?
How do I create a trace in sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?