EXECUTE/ sp_executesql

• Ramya P

  Grasshopper

  Points: 21

  More actions

  December 28, 2004 at 12:05 am

  #163464

  Hi,

  Is it possible to use EXECUTE/ sp_executesql in a function to execute a string sql.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  December 28, 2004 at 2:40 am

  #535108

  No, you can't use dynamic sql within a UDF. You need to try to workaround this.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]