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

What are the advantages of sql azure?

140

What does sql server mean?

986

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

984

Which tools are available to manage SQL Azure databases and servers?

113

What are pages and extents? : SQL Server Architecture

968

What is difference between line feed ( ) and carriage return ( )?

857

Can you name a few encryption mechanisms in sql server?

901

what authentication modes does sql server support? : Sql server database administration

1016

How to create a view on an existing table in ms sql server?

1067

Is truncate autocommit?

902

What are filegroups in sql server?

1020

Define inner join in sql server joins?

995

What are logical database components? : SQL Server Architecture

971

Explain powershell included in sql server 2008?

1013

What is molap and its advantage? : sql server analysis services, ssas

934