Export (0) Print
Expand All

SqlFunctionAttribute Class

Used to mark a method definition of a user-defined aggregate as a function in SQL Server. The properties on the attribute reflect the physical characteristics used when the type is registered with SQL Server.

Namespace: Microsoft.SqlServer.Server
Assembly: System.Data (in system.data.dll)

[SerializableAttribute] 
[AttributeUsageAttribute(AttributeTargets.Method, AllowMultiple=false, Inherited=false)] 
public class SqlFunctionAttribute : Attribute
/** @attribute SerializableAttribute() */ 
/** @attribute AttributeUsageAttribute(AttributeTargets.Method, AllowMultiple=false, Inherited=false) */ 
public class SqlFunctionAttribute extends Attribute
SerializableAttribute 
AttributeUsageAttribute(AttributeTargets.Method, AllowMultiple=false, Inherited=false) 
public class SqlFunctionAttribute extends Attribute
Not applicable.

The following example shows an aggregate function that returns a list of files in the specified directory path.

[SqlFunctionAttribute(FillRowMethodName = "FillFileRow")]
public static IEnumerable GetFileDetails(string directoryPath)
{
   try
   {
      DirectoryInfo di = new DirectoryInfo(directoryPath);
      return di.GetFiles();
   }
   catch (DirectoryNotFoundException dnf)
   {
      return new string[1] { dnf.ToString() };
   }
			
}

System.Object
   System.Attribute
    Microsoft.SqlServer.Server.SqlFunctionAttribute
       Microsoft.SqlServer.Server.SqlMethodAttribute

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Windows 98, Windows Server 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0

Community Additions

ADD
Show:
© 2014 Microsoft