Цитата:
Сообщение от
polygris
egorych куда UDF возвращает? UDF возвратит recordSet если сделать SELECT UDF()
а есть какой-то другой способ вызова UDF ?
Цитата из BOL
Цитата:
Calling User-Defined Functions
When calling a scalar user-defined function, you must supply at least a two-part name:
SELECT *, MyUser.MyScalarFunction()FROM MyTableTable-valued functions can be called by using a one-part name:
SELECT *FROM MyTableFunction()However, when you call SQL Server built-in functions that return a table, you must add the prefix :: to the name of the function:
SELECT * FROM ::fn_helpcollations()