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 update values in a table with update statements in ms sql server?

0 Answers  

---

what is mean by constraints in sql?

5 Answers   Granada, IBM,

---

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

---

If no size is defined while creating the database, what size will the database have?

0 Answers  

---

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

---

---

Can you name a few encryption mechanisms in sql server?

0 Answers  

---

What is the meaning of sql server?

0 Answers  

---

what information is maintained within the msdb database? : Sql server administration

0 Answers  

---

How to tune a stored procedure?

6 Answers  

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

What is a raid and what are different types of raid configurations?

0 Answers  

---

What is the importance of a recovery model?

0 Answers  

---