Yes, we can. Eg: create proc Test as select getdate() GO -- EXEC Te

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

Question Posted / suraj

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to retrieve error messages using mssql_get_last_message()?

992

Which language rdl files made of?

124

What is policy based management (pbm)? : sql server database administration

928

How do indexes help, types?

909

How to populate a table in sql server?

892

Explain having clause and where clause?

989

Explain the Ways to improve the performance of a sql azure database?

What does it mean if @@cursor_row returns a negative number?

942

Do you know spatial data types - geometry and geography in sql server 2008?

969

How many databases instances are there in sql server 2000?

1023

How to integrate the ssrs reports in application?

934

How to use wildcard characters in like operations in ms sql server?

1063

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2667

What are truncate options available in sql server? : sql server database administration

966

What is the recovery model?

931