|  | Posted by Gert-Jan Strik on 07/21/07 22:42 
Sorry about the confusion. I first tested on SQL Server 2000 and later(when Hugo gave a reply) I retested on 2005.
 
 In SQL Server 2005, this all works just fine. All you need to do is
 access the scalar UDF with its 2-part name.
 
 However, in SQL Server 2000 (the OP's platform), it doesn't work.
 Calling it with the 2-part name gives the error "Incorrect syntax near
 '.'", calling it with the 1-part name gives the error "Incorrect syntax
 near '('.". Schemabinding doesn't make a difference.
 
 Gert-Jan
  Navigation: [Reply to this message] |