此頁只有英文版

TotallySQL joins ComponentSource

Extend and enhance your T-SQL programming environment by adding powerful functions built right into the database layer.

放大 [+]

The functions available with SQLFinancials.

The following TotallySQL products are now available:

• SQLFinancials 50+ financial functions and aggregates that faithfully replicate and extend all the financial analysis features available in Microsoft Excel.
• SQLStatistics 80+ functions and aggregates including every kind of statistical test and metric.
• SQLUtilities 20+ date and time related functions, 37 string and text processing functions, 3 useful numeric functions and 3 relative column reference aggregate functions.

Features

SQLFinancials extends and enhances your T-SQL programming environment by adding 50+ powerful new financial functions and aggregates that faithfully replicate and extend all the financial analysis features available in Microsoft Excel. SQLFinancials includes: 29 functions for calculating yields, rates, coupon periods etc. for corporate and government bonds, 7 functions for calculating depreciation on various bases, 15 functions for calculating interest payments, rates, principal payments, durations, present and future values etc. for loans or investments, 3 functions for calculating internal rates of return for a series of cashflows and 2 functions for converting between dollar fractions and decimal values.

SQLStatistics extends and enhances your Transact-SQL programming environment by adding 80+ powerful new functions and aggregates. Functions include a portfolio of tests and metrics of correlation, similarity or dependence between datasets, including chi-squared tests of independence and goodness of fit; covariance metrics; F-tests to compare variances; paired and unpaired Student's-T tests to compare means; Pearson's product moment correlation coefficient and its square; the Fisher transformation; and the Z-test. SQLStatistics also includes a broad range of descriptive statistics including geometric, harmonic and quadratic means; truncated and inter-quartile means and the tri-mean; modes of both continuous and discrete data; medians, quartiles, percentiles, percentile rank and absolute rank; skewness and kurtosis; weighted averages, variances, standard deviations and power means; range, mid-range, inter-quartile range, nth largest, nth smallest and more.

SQLUtilities extends and enhances your T-SQL programming environment by adding: 21 date and time related functions, including a table-valued date and time sequence generator; random date and time generators; working days calculations; date and time arithmetic; formatting, parsing and type conversion, 37 string and text processing functions including string concatenation functions and aggregates; scalar and table-valued tokenized string parsing; advanced formatting, searching and substitution; regular expressions processing; collation-free comparisons; type conversions., 3 useful numeric functions - including a table-valued numberline sequence generator - allowing you to generate any required set of incremental numeric values of any size on the fly without having to create and maintain lookup tables, and two excel-like random number generators that are easier to use than the built-in T-SQL RAND() function and 3 relative column reference aggregate functions, allowing you to select values from multiple columns in an aggregation from the row that contains the maximum, minimum or a matching value of one column.

About TotallySQL

TotallySQL are specialists in application development centered around Microsoft SQL Server, and in particular in creating CLR-based function libraries that enable advanced processing to be carried out within the database itself. They provide a range of off-the-shelf function libraries and can also build bespoke libraries to your specification. They also provide a range of database and data management services - including database design, ETL services, data cleansing and data migration.