difference between stored procedure and function?

Answer Posted / vsandhyana

Function can call anywhere in your select query but store
procedure cannot call from the select statement.

store procedure may or may not return values but function
should return value.

Thanks,
Vsandhyana

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between set functions and filter function in dimensional data?

2684


What is a Datastore in Cognos?

1015


how u will design the report if the objects are available

2516


How to generate cubes in cognos?

739


What are initial page components of Cognos connection?

795


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2495


Explain difference between powerplay transformer and power play reports?

722


What is the enterprise class platform architecture of cognos 8?

788


What are the types of hierarchies?

768


How is possible this scenario using in type-in prompt.?

768


what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us

2731


How do we drill through from a powerplay cube to reportnet?\

2098


What is the metric store database?

721


Define dimensions?

800


What is called cognos reporting tool?

783