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 we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

What is the partitioning method?

0 Answers  

---

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

---

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

0 Answers  

---

What is abstracting periodical?

0 Answers  

---

What is the difference between local table and global table

1 Answers   CarrizalSoft Technologies, Polaris,

---

What is the difference between a primary key and a unique key? Are they the same?

0 Answers  

---

What does <> symbol mean?

0 Answers  

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

0 Answers  

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  

---

How we can compare two database data?

0 Answers  

---