It would be handy, if AGS utility can provide a function to delete log,
Function |
Purpose |
AGS_ReadfromEventLog |
Read an event log and returns a table of event items. |
AGS_WritetoEventLog |
Writes an entry to an event log on a given computer. |
Export Functions
Exporting functions are also common these days. This tool supports exporting CSV, HTML, and XML files. It would be nice if this tool could export to PDF as well.
Function |
Purpose |
AGS_Export2XML |
Outputs a query to an XML file. |
AGS_Export2HTMLTable |
Outputs a query in table format to an HTML file. |
AGS_Export2CSV |
Outputs a query to a CSV file. |
Internet Functions
Most developers would like to save an IP address in integer format rather than standard IP format. The ability to convert back and forth between these formats is important.
Function |
Purpose |
AGS_ConvertIPAddress2IPNumber |
Takes an IP address and turns it into an IP number. |
AGS_ConvertIPNumber2IPAddress |
Takes a number and turns it into an IP address string. |
Math Functions
A limited number of functions are provided under this category. This tool should definitely be expanded to include functions like Log, ln, nCp, and nCr.
Function |
Purpose |
AGS_Math_E |
Returns the natural logarithmic base, specified by the constant, e. 2.7182818284590452354. |
AGS_Math_Factorial |
Calculates the factorial of the input number. |
AGS_Math_IEEERemainder |
Returns the remainder resulting from the division of a specified number by another specified number. |
AGS_Math_PI |
Returns PI. 3.14159265358979323846. |
AGS_Math_Remainder |
Calculates the remainder of the quotient of two 32-bit signed integers. |
AGS_Math_Truncate |
Returns the integral part of the number without rounding. |
String Functions
Function |
Purpose |
AGS_FormatDate |
This function will take a date input and return a string formatted date. |
AGS_FormatNumber |
Takes a number input and returns a string formatted date. |
AGS_PadString |
Pads the input string out to the required total width. |
AGS_Split2Table |
Returns a table of split elements. |
AGS_WordCount |
Returns a count of all the words in the input string. |
Stored Procedure |
Purpose |
AGS_SplitString |
Allows you to iterate through a string of delimitated elements. |
Version Information Function
Function |
Purpose |
AGS_Version |
Returns the version number text for the AGS SQL Server 2005 Utilities assembly. |