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 size of the cube?

609


5. Which type of report you build more, list, crosstab or chart and why?

1681


hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

1696


Explain the different types of views used in cognos.

611


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

2628






what are the filters in framework manager and report studio?

677


Can you define cognos powerplay?

728


What is the use of powerhouse?

693


can we insert all types of charts in a list report? what r the realtime prompts?

1767


How to deploy from one server to another server?

2104


What is a Query Subject?

756


what are the features in cognos8ui

1642


what are the errors faced while bursting the reports and how to solve those errors?

1643


How can you link a query to a data container manually in Report Studio?

2021


Define datastores in cognos?

637