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 |
Difference between report and query parameter. Why do we need different type of parameter?
List out some of the requirements to set up a sql server failover cluster?
What is the use of @@spid?
What is sql language?
How to include text values in sql statements?
What are .mdf files?
Describe in brief authentication modes in sql server.
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?
what is a transaction and what are acid properties? : Sql server database administration
What is page in sql server?
How to create new databases with "create database" statements?