can we call functions from stored procedure in SQL Server
2005 ? How?
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 |
Post New Answer View All Answers
What is an entity-relationship diagram (erd)?
How to execute a sql statement using mssql_query()?
Explain full-text indexing?
How to add the custom code in Report?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
how many type of indexing in database?
Explain the benefits of user-defined functions?
Describe the left outer join & right outer join. : sql server database administration
How to find the second highest salary of an employee?
What are the drawbacks of reporting in ssrs?
How to get a list of columns using the "sys.columns" view in ms sql server?
Explain the Ways to improve the performance of a sql azure database?
What is the maximum row of a size?
How the authentication mode can be changed?
what happens on checkpoint? : Sql server database administration