Function to Calculate Simple Interest In SQL Server

Introduction Whenever working in Financial Applications like Banking applications or financial modules in any ERP application we might have seen as Simple Interest. Usually we do those calculations in the programming application or else in the Frontend side and pass that calculated value to the database tables. But we can also do the same simple... Continue Reading →

SQL Server Date Functions

Introduction Date and Time plays major role in many projects. SQL Server has several date and time functions. In this article, we will discuss all the Date and Time functions in SQL Server with an Example. CURRENT_TIMESTAMP() Returns the date and time of the machine the SQL Server is running on. Example SELECT CURRENT_TIMESTAMP AS... Continue Reading →

Website Built with WordPress.com.

Up ↑

%d bloggers like this: