hi,
Scalar functions (sometimes referred to as User-Defined Functions / UDFs) return a single value as a return value, not as a result set, and can be used in most places within a query or SET statement, except for the FROM clause (and maybe other places?). Also, scalar functions can be called via EXEC, just like Stored Procedures, though there are not many occasions to make use of this ability.
table functions are functions that users can query like any other database tables, and you can add it as a data source in your graphical calculation views. You can use the from clause of a SQL statement to call a table function.
regards,
sowmya.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.