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
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
How to select multiple values from type-in prompt?
What is difference between content store and content manager?
Explain difference between powerplay transformer and power play reports?
How do you call a store procedure within a transformation?
What are the advantages of cognos?
What is meant by alternate drill down with ex?
Name the types of gateway?
What is a Transformer?
Can you define a catalog and types of catalogs in cognos?
What do you mean by drill across?
What is Fullouterjoin?
how to merge 2 crosstabs thans
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.
What are the components of report net?