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 the role of cognos comsultant?what actually it means?pls reply
What are the different uses of a repository manager?
What are the components used in web tier?
what is stitch query in reportnet?
What is model filter?
What are the batches and it’s details?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
--------------Diff b/w ODS and OLAP?
------------ Diff b/w MemberCaption and MemberDescription?
What is the deployment requirements used in cognos?
Define the slice and dice?
how u will design the report if the objects are available
What are the different types of reports present 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.
4. How many dimensions did you use in your reports?