Product Reviews

All Reviews

Audit Tools

Backup Tools

Change Management Tools

Clustering Tools

Coding Tools

Design Tools

Diff / Compare Tools

Documentation Tools

Job Management Tools

Log Recovery Tools

Monitoring Tools

Remote Access Tools

Reporting Tools

Security Tools

Testing Tools

Write for Us

Share you SQL Server knowledge with others and raise your profile in the community More...

Free Yourself from Writing Common Functions with AGS SQL Server 2005 Utilities

By : Dinesh Asanka
May 31, 2006

Page 2 / 3

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.

<< Prev Page Next Page>>