SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Store Procedures and User Defined Functions		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

abhijaiswal.84
Starting Member

India
29 Posts
Posted - 05/18/2012 :  04:52:52  Show Profile  Reply with Quote
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

Norway
3241 Posts
Posted - 05/18/2012 :  06:01:19  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000