PRB: Cannot Pass Function as Parameter to Table Valued User Defined Function (312323)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q312323 SYMPTOMS
When you pass a user defined function (UDF) or a system function as an input parameter to a UDF that returns a table variable, the statement fails with the following error message:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '('
If the UDF returns a scalar variable instead of a table variable then it works fine.
CAUSE
SQL Server dissallows anything but compile time constants from being in the parameter list of table valued functions.
STATUS
This behavior is by design.
Modification Type: | Major | Last Reviewed: | 10/3/2003 |
---|
Keywords: | kbprb KB312323 |
---|
|