udf

SQL Server: can a stored proc that updates tables be called from within a CLR UDF

I don't know why, but CLR User Defined Functions are not allowed to update tables. Is it possible to work around this restriction by calling a stored procedure from the CLR UDF that updates tables for it ? ...

MySQL User Defined Function to send a windows message...

G'Day, I want to use the Windows API Postmessage() call from inside a MySQL UDF on MySQL 5.1.51 (XP SP3). I know the UDF (Written in Delphi 2006) is working by setting a bogus result for the UDF. The syntax of the UDF takes two integer params, one for a window handle and the other for a message number. However a call to PostMessage() ...

How to create a UDF in the master database that references the correct sys.objects table?

Using SQL Server 2008, I'd like to create a UDF that gives me the create date of an object. This is the code: create function dbo.GetObjCreateDate(@objName sysname) returns datetime as begin declare @result datetime select @result = create_date from sys.objects where name = @objname return @result end go I'd like to put t...