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


can we call functions from stored procedure in SQL Server
2005 ? How?

Answers were Sorted based on User's Feedback



can we call functions from stored procedure in SQL Server 2005 ? How?..

Answer / monal

Yes you can call function from stored procedure, so far i
haven't had a chance to use it, but still would like to give
it a shot:
As per my guess you can call function in SP using select
statement as you would execute function usually.

Is This Answer Correct ?    26 Yes 5 No

can we call functions from stored procedure in SQL Server 2005 ? How?..

Answer / mukki

Yes

Is This Answer Correct ?    19 Yes 5 No

can we call functions from stored procedure in SQL Server 2005 ? How?..

Answer / suraj

Yes, we can.
Eg:
create proc Test
as
select getdate()
GO

-- EXEC Test
-- in the above query getdate() is a system function.

Is This Answer Correct ?    16 Yes 5 No

Post New Answer

More SQL Server Interview Questions

What is the order in which the sql query is executed?

0 Answers  


what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  


Give me a SQL Query to find out the second largest company?

0 Answers   Ernst Young,


How does recursive cte works in sql server?

0 Answers  


What is the difference between dataadapter and datareader?

0 Answers  


How to insert data with null values?

0 Answers  


What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,


I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.

7 Answers  


Explain various data region available in ssrs with their use?

0 Answers  


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,


What are the different ways you can create databases in sql server?

0 Answers  


Categories