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

How to call stored procedure using http soap?

0 Answers  


When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  


How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  


What is the difference between system objects and user objects?

0 Answers   HCL,


Where are sql server usernames and passwords stored in the sql server?

0 Answers  


What is a recursive stored procedure in sql server?

0 Answers  


What are the properties of primary key?

0 Answers  


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

0 Answers  


How you can change a cross join into an inner join?

0 Answers  


how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,


What are all new concepts in SQL Server 2008? That is Exactly Difference between 2005 to 2008

2 Answers   IBM,


What is GUID in sql server?

0 Answers   BirlaSoft,


Categories