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
What is defined as catalog and types of catalogs in Cognos?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
--------------Explain Table of contents?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
How to do Performence Tunning in Cognos Reports?
How do you Parametermap variables in Quiries?
What is model?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
what is log in cognos?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
What are the message flows?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What do you mean by drill across?