View Single Post
  #1 (permalink)  
Old September 4th, 2003, 03:28 PM
flyin flyin is offline
Authorized User
Join Date: Sep 2003
Location: , , .
Posts: 93
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to flyin
Default Calling a Function within an MS SQL Statement

I am currently finding a solution to a problem i have and i was hoping the great minds of the forums could help. The problem goes as fallows: I am wondering if there is a way to access a function called getUserPoints() stored in a COM object within an MS SQL Statement. For instance,
in a programming manner i want to do something like this:
"Update [table] Set Points = " & getUserPoints(param1, param2) & " WHERE ID=9". I know you can do this with PL/SQL, but is there a solution for MS SQL????