Facebook pixel tracking

The Science and Information (SAI) Organization publishes open-access peer-reviewed journals in computer science and artificial intelligence.

Contact Info
Email info@thesai.org
Website thesai.org
Follow Us
Contact Info
Email info@thesai.org
Follow Us
Research Article | Open Access |

User-Defined Financial Functions for MS SQL Server

Author 1: Jolana Gubalova Author 2: Petra Medvedova
International Journal of Advanced Computer Science and Applications (IJACSA) · Vol. 9, No. 9 · Published 2018

DOI: https://doi.org/10.14569/IJACSA.2018.090903

Download PDF Cite Call for Papers

Abstract

The paper deals with mathematical preparation and subsequent programming of various types of financial functions with using of Transact-SQL in Database Management System MS SQL Server. Financial functions are used to automate calculations in the area of Financial Economics. In MS SQL Server, any financial functions are not offered for financial data processing, how such as in program MS Excel. We emphasize that we have used a different calculation methods to create financial formulas, not those used in Excel. If users want to work with some special functions, there is a possibility to prepare User-Defined Functions (UDFs). The use of UDFs will make it easier to work on financial calculations in large databases.

Keywords

Financial economics user-defined functions financial functions database management system structure query language transact-SQL

How to Cite this Article

Gubalova, J., & Medvedova, P. (2018). User-Defined Financial Functions for MS SQL Server. International Journal of Advanced Computer Science and Applications, 9(9). https://doi.org/10.14569/IJACSA.2018.090903

Gubalova, Jolana, and Petra Medvedova. "User-Defined Financial Functions for MS SQL Server." International Journal of Advanced Computer Science and Applications, vol. 9, no. 9, 2018, https://doi.org/10.14569/IJACSA.2018.090903.

@article{Gubalova2018,
  title     = {User-Defined Financial Functions for MS SQL Server},
  journal   = {International Journal of Advanced Computer Science and Applications},
  volume    = {9},
  number    = {9},
  year      = {2018},
  publisher = {The Science and Information Organization},
  author    = {Jolana Gubalova and Petra Medvedova},
  doi       = {10.14569/IJACSA.2018.090903},
  url       = {https://doi.org/10.14569/IJACSA.2018.090903}
}

Open Access — licensed under a Creative Commons Attribution 4.0 International License. Unrestricted use, distribution, and reproduction in any medium, even commercially, as long as the original work is properly cited.

Back to Issue
IJACSA Journal Cover

IJACSA