ExpressionNodeFunction.Function Enum

Definition

Namespace:

Microsoft.SqlServer.Management.Dmf

Assembly:

Microsoft.SqlServer.Dmf.dll

Package:

Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Type of Function

public enum ExpressionNodeFunction.Function

type ExpressionNodeFunction.Function = 

Public Enum ExpressionNodeFunction.Function

Inheritance

Enum

ExpressionNodeFunction.Function

Fields

Name	Value	Description
ExecuteSql	0	Execute scalar SQL
ExecuteWql	1	Execute WMI query
GetDate	2	Get current date
DateAdd	3	Add a number to a date
DatePart	4	Extract a part of a date
Sum	5	Sum a series of values
Avg	6	Average a series of values
Count	7	Count a series of values
Len	8	Get the length of a string
IsNull	9	Substitute a value for null
Array	10	Return an array of values
Add	11	Add two values
Subtract	12	Substract two values
Multiply	13	Multiple two values
Divide	14	Divide one value by another
BitwiseAnd	15	Bitwise AND
BitwiseOr	16	Bitwise OR
Power	17	Raise a value to an exponential power
Mod	18	Return the modulus of one number divided by another
Round	19	Round a number
Enum	20	Return the textual description for an enum
DateTime	21	Return a datetime from a string
String	22	Convert a value to a string
True	23	Logical true
False	24	Logical false
Guid	25	Return guid from string
Upper	26	Return upper-case string
Lower	27	Return lower-case string
Concatenate	28	Concatenate strings
Escape	29	Escape string Defect 247787, Ability to pass dynamic Arguments to ExecuteWQL