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 bind a view to the schema of the underlying tables?

1 Answers  

---

How to create a user to access a database in ms sql server using "create user" statements?

1 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

---

Do you know what are acid properties of transaction?

1 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

---

How to convert a numeric expression from one data type to another?

1 Answers  

---

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

1 Answers  

---

What is a heap?

1 Answers  

---

What is sql server 2000 work load governor?

1 Answers  

---

What is Transparent Data Encryption?

1 Answers  

---

Explain active/passive and active/active cluster configurations?

1 Answers  

---

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---