Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 role of cognos comsultant?what actually it means?pls reply

2263


What are the different uses of a repository manager?

1033


What are the components used in web tier?

941


what is stitch query in reportnet?

1049


What is model filter?

1119


What are the batches and it’s details?

923


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..

1884


--------------Diff b/w ODS and OLAP?

3162


------------ Diff b/w MemberCaption and MemberDescription?

2278


What is the deployment requirements used in cognos?

1600


Define the slice and dice?

970


how u will design the report if the objects are available

2711


What are the different types of reports present in cognos?

946


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.

2034


4. How many dimensions did you use in your reports?

1898