Top "User-defined-functions" questions

A function provided by the user of a program or an environment most often for spreadsheet type applications or database applications.

Refresh Excel VBA Function Results

How can I get a user-defined function to re-evaluate itself based on changed data in the spreadsheet? I tried F9 …

excel vba user-defined-functions
Execute Stored Procedure from a Function

I know this has been asked to death, and I know why SQL Server doesn't let you do it. But …

sql sql-server sql-server-2005 stored-procedures user-defined-functions
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.Splitfn", or the name is ambiguous

Hai guys, I ve used the following split function, CREATE FUNCTION dbo.Splitfn(@String varchar(8000), @Delimiter char(1)) returns @temptable TABLE (…

sql-server sql-server-2005 tsql user-defined-functions
TSQL How do you output PRINT in a user defined function?

Basically I want to use PRINT statement inside a user defined function to aide my debugging. However I'm getting the …

tsql user-defined-functions
Define all functions in one .R file, call them from another .R file. How, if possible?

How do I call functions defined in abc.R file in another file, say xyz.R? A supplementary question is, …

r file scope namespaces user-defined-functions
SQL Server: How to call a user-defined function (UDF) on linked server?

i'm trying to call a User-Defined Function (UDF) on a linked server: CREATE FUNCTION [dbo].[UserGroupMembershipNames](@UserGUID uniqueidentifier) RETURNS VARCHAR(8000) …

sql-server sql-server-2000 linked-server user-defined-functions
Calling SQL Functions directly from C#

I have a requirement to run a query against a database that will return either a zero or one (Checking …

sql sql-server stored-procedures user-defined-functions
Remote table-Valued Function Calls are not allowed

How can I make this work?Im running a table valued function from a remote linked server. i tried adding …

sql sql-server user-defined-functions nolock
How do I test a Table-Valued Function in SQL Server Management Studio?

I've never worked with Database Functions, but my current project requires it. I need to put a common sql query …

sql sql-server user-defined-functions
How to report an error from a SQL Server user-defined function

I'm writing a user-defined function in SQL Server 2008. I know that functions cannot raise errors in the usual way - …

sql sql-server tsql sql-server-2008 user-defined-functions