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

Explain Capacity planning to create a database? and how to monitor it?

4243

What is proper subset of candidate key?

1039

What is the difference between value type and reference type?

987

What is the difference between SQL notification and SQL invalidation?

1262

How to use order by with union operators in ms sql server?

1063

How to change the data type of an existing column with "alter table" statements in ms sql server?

1034

What is primary key index?

1015

what is a correlated sub-query? : Sql server database administration

989

What is the partitioning method?

1064

How can a database be repaired?

1032

In which files does sql server actually store data?

949

What is replace and stuff function in sql server?

1111

How do you size a resultset?

965

What are the different types of collation sensitivity in sql server?

1162

How to end a stored procedure properly in ms sql server?

1141