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

Do you know what is replace and stuff function in sql server?

1015

What is query optimization process?

1012

What are the different subsets of sql?

1551

What is difference between joins and subqueries?

1120

What is primary key and example?

954

How network traffic be reduced by using the stored procedure?

1118

What are the basic functions for master, msdb, model, tempdb databases?

1042

What is sql injection and why is it a problem? : sql server security

1132

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

977

What is optimistic concurrency?

1038

What are the general features of sql server management studio? : sql server management studio

1077

What is the difference between count () and rowcount ()?

1027

How to add code to the existing article (using improve article)?

1110

Can we use where clause with group by?

901

What is sql collation?

1210