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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / swapnil

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 contrast between sql and mysql?

0 Answers  

How to run sql server 2005 books online on your local system?

0 Answers  

How will you optimize a stored procedure optimization?

0 Answers  

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

What are the advantages of using stored procedures?

0 Answers  

can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,

Why is normalisation important?

0 Answers  

Describe in brief databases and sql server databases architecture.

0 Answers  

I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.

4 Answers   Satyam,

How do I get to sql server configuration manager?

0 Answers  

Explain the dbcc pintable command when would you use it?

0 Answers  

What are defaults? Is there a column to which a default can't be bound?

2 Answers   TCS,

For more SQL Server Interview Questions Click Here
Categories