May 17, 2006 at 9:48 pm
sp_executesql is an extended sp
how come i can't use this inside a function?
get this error
Only functions and extended stored procedures can be executed from within a function.
May 17, 2006 at 10:26 pm
Extended stored procedures have names prefixed with 'xp_'...
May 17, 2006 at 11:07 pm
sp_execute is listed under 'Extended Stored Procedures' -> 'System Extended Stored Procedures' in SQL 2005
May 18, 2006 at 12:06 am
According to MSDN2 (http://msdn2.microsoft.com/en-us/library/ms187961.aspx), sp_executesql is listed under category [Database Engine Stored Procedures], whilst 'xp_' stored procedures are listed under [General Extended Stored Procedures]!
May 18, 2006 at 5:41 am
i'm looking at my sql 2005, and it's listed where i said it was.
May 18, 2006 at 6:48 am
sp_executesql is not an extended sp it is internal to sql server, extended sp (xp_) are dll's
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply