can we call functions from stored procedure in SQL Server
2005 ? How?
Answers were Sorted based on User's Feedback
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 |
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 |
How to find the date and time of last updated table?
What is a coalesce function?
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?
Tell me what is fill factor?
How are the unique and primary key constraints different?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
How to find which stored procedure is currently running in sql server?
How to test subquery results with the exists operator?
What is ssl in sql server?
What is a Trace frag?Where can we use this?
Explain the creation and execution of a user-defined function in the sql server?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration