If you want to use a field from the returned table in a local variable you can use the following: SELECT Top 1 @Name=[Name] from [dbo].FN('Some text') I have a similar problem in that I …

Jan 26, 2014 · how to call scalar function in sql server 2008 Each time, I try entering the Function using the syntax shown here in SQL Server Management Studio, or SSMS, to see the results, …

I have a user defined function in SQL called getBuisnessDays it takes @startdate and @enddate and returns the number of business days between the two dates. How can I call that function …

Also, it's not true that "If a function called a stored procedure, the function would become able to have side-effects" since SQL Server can prevent just those forbidden actions, as it does when …

Oct 31, 2012 · sql-server t-sql function asked Oct 31, 2012 at 19:19 gabsferreira 3,167 7 40 62

Mar 10, 2022 · A function cannot use EXEC, and a VIEW must be well defined; it's just a pseudo table defined by a SELECT. Ideally leave dynamic pivoting to your reporting layer.

Sep 1, 2016 · You can't execute stored procedures inside a function. In this case you are trying to use the procedure sp_executesql inside the function and that is causing this issue.

Aug 12, 2015 · This works to retrieve the return value of a stored procedure, but not dynamic SQL.

Feb 11, 2010 · How do you assign the result of an exec call to a variable in SQL? I have a stored proc called up_GetBusinessDay, which returns a single date. Can you do something like this: …

The function name ExecuteScalar is frustratingly misleading when calling SQL Scalar Functions instead of SQL Store Procedures. But the behaviour does match the documentation