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

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.

Continues…

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |