Answer / monal

Yes you can call function from stored procedure, so far i
haven't had a chance to use it, but still would like to give
it a shot:
As per my guess you can call function in SP using select
statement as you would execute function usually.

Answer / mukki

Yes

Answer / suraj

Yes, we can.
Eg:
create proc Test
as
select getdate()
GO

-- EXEC Test
-- in the above query getdate() is a system function.

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

What is the order by used for?

0 Answers  

---

How can I check if a view exists in a sql server database?

0 Answers  

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

0 Answers  

---

What is the purpose of using COLLATE in a query?

1 Answers  

---

---

What is self contained sub query?

0 Answers  

---

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

---

How you can change a cross join into an inner join?

0 Answers  

---

Where is trigger in sql server?

0 Answers  

---

How to use subqueries with the exists operators in ms sql server?

0 Answers  

---

How to compare the top two records using sql?

0 Answers  

---

How to optimize stored procedures in sql server?

0 Answers  

---