can we call functions from stored procedure in SQL Server
2005 ? How?
- 3 Answers
- 10787 Views
- I also Faced
- E-Mail Answers
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 the main purpose of having conversation group?
How you trouble shoot when any job fails
What the different components in replication and what is their use?
Do you know what is rank function?
What is the difference between functions and scalar functions?
What is "scheduled jobs" or "scheduled tasks"?
Explain trigger classes i.e. Instead of and after trigger?
Explain about SQL server 2005?
How to create a simple table to test triggers in ms sql server?
Explain the difference between control flow and data flow?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What are the advantages of user defined function?
What is t-sql script to take database offline – take database online.
what is the difference between delete table and truncate table commands? : Sql server database administration
