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

Difference between report and query parameter. Why do we need different type of parameter?

0 Answers  


List out some of the requirements to set up a sql server failover cluster?

0 Answers  


What is the use of @@spid?

0 Answers  


What is sql language?

0 Answers  


How to include text values in sql statements?

0 Answers  






What are .mdf files?

0 Answers  


Describe in brief authentication modes in sql server.

0 Answers  


Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,


How many types of schemas are there?

0 Answers  


what is a transaction and what are acid properties? : Sql server database administration

0 Answers  


What is page in sql server?

0 Answers  


How to create new databases with "create database" statements?

0 Answers  


Categories