Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Store Procedures and User Defined Functions

Author  Topic 

abhijaiswal.84
Starting Member

29 Posts

Posted - 2012-05-18 : 04:52:52
Hi,

Can anyone help me to find the answer for below question,

Can a Store Procedure be called from UDF and can a UFD be called from SP.

If yes then can you give a small example.

Thanks in advance.

Rgds,
Abhi

Abhishek

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2012-05-18 : 06:01:19
You can call a function from within a stored procedure but not the other way around. The only exception is that you can actually execute extended stored procedures (i.e. xp_cmdshell) from inside a UDF.

- Lumbago
My blog-> http://thefirstsql.com
Go to Top of Page
   

- Advertisement -