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.

How to write character string constants or literals in ms sql server?

0 Answers  

---

how you can list all the tables in a database?

0 Answers  

---

What is unpivot?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

What is built-in function?

0 Answers  

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

Is port 1433 secure?

0 Answers  

---

How do I run sql server 2014?

0 Answers  

---

What is the maximum size of column in sql server?

0 Answers  

---

How to search for a string in all stored procedure in sql server?

0 Answers  

---

List few advantages of stored procedure.

0 Answers  

---