functions in Execute SQL Task

• Daniel Klionsky

  Mr or Mrs. 500

  Points: 555

  More actions

  March 27, 2002 at 5:22 pm

  #104784

  Hi,

  I'm having trouble executing my user-defined function from "Execute SQL Task".

  My statement looks like:

  Update tbl1

  set col1=dbo.my_function(col2)

  When I execute Execute SQL Task nothing happens to my data.

  What am I missing??

  I'm using SQL Server2000

  thanks!

• Daniel Klionsky

  Mr or Mrs. 500

  Points: 555

  More actions

  March 28, 2002 at 12:05 pm

  #426244

  I found a problem.

  my_function was written by me incorrectly.