Calling Scalar-valued Functions in SQL Asked 14 years, 2 months ago Modified 6 years, 4 months ago Viewed 141k times

Jul 14, 2016 · What is the difference between scalar-valued, table-valued, and aggregate functions in SQL server? And does calling them from a query need a different method, or do we call them in the …

This behaviour is different from using parameters with default values in stored procedures in which omitting the parameter also implies the default value. An exception to this behaviour is when invoking …

Sep 28, 2009 · I'm writing a user-defined function in SQL Server 2008. I know that functions cannot raise errors in the usual way - if you try to include the RAISERROR statement SQL returns: Msg 443, …

Oct 4, 2012 · If you're calling a UDF from within another query (e.g. a scalar function in a SELECT, or a table-valued function in a FROM or JOIN) then you can't use EXECUTE btw. But what's wrong with …

Why do Scalar-valued functions seem to cause queries to run cumulatively slower the more times in succession that they are used? I have this table that was built with data purchased from a 3rd par...

Oct 12, 2023 · sql-server function t-sql user-defined-functions edited Oct 12, 2023 at 22:00 Dale K 28.1k 15 59 85

Apr 20, 2015 · 5 I have to run a query from linked server (SQL Server 2008) that contains Scalar UDF (with one parameter) on that server, when I run the query I got following error

Mar 30, 2023 · 4 How can I run a scalar valued function from c# and get its value? For a table-based function, I use a select command and get the resulting DataTable, but I am clueless on how to do it …

I want to get one value from a function using a case statement. I tried the following but it does not work: