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 find the date and time of last updated table?

3 Answers  


What is a coalesce function?

0 Answers  


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

0 Answers   Verizon,


Tell me what is fill factor?

0 Answers  


How are the unique and primary key constraints different?

0 Answers  






John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

0 Answers  


How to find which stored procedure is currently running in sql server?

0 Answers  


How to test subquery results with the exists operator?

0 Answers  


What is ssl in sql server?

0 Answers  


What is a Trace frag?Where can we use this?

1 Answers  


Explain the creation and execution of a user-defined function in the sql server?

0 Answers  


What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  


Categories