SQL Server 2012

Convert Decimal to Money SQL

In this article, I will explain how to Convert Decimal Numbers to Money with cents / without cents in SQL. You might also like to read How to convert Gregorian date to Hijri date SQL Server 2012 Convert Decimal to Money SQL I have a decimal number like  71567536.100000, I need to convert it to money format with …

Convert Decimal to Money SQL Read More »

Microsoft Report Viewer 2012 Runtime is missing Microsoft System CLR Types for SQL Server 2012

In this article, we will solve the “Setup is missing an installation prerequisite: Microsoft System CLR Types for SQL Server 2012” issue that you may face when installing Microsoft Report Viewer 2012 Runtime. You might also like to read Failed to load the appropriate report editor in PerformancePoint Dashboard Designer in SharePoint Server 2013 Missing …

Microsoft Report Viewer 2012 Runtime is missing Microsoft System CLR Types for SQL Server 2012 Read More »

How to convert Gregorian date to Hijri date SQL Server 2012

In this post, I will explain How to convert Gregorian date to Hijri date SQL Server 2012 Convert Gregorian date to Hijri date in SQL Server SQL Server 2012 introduces a new Format function that used to achieve the same result. Output 16/08/1435 You can also use the below query Output 16/08/1435 3:42:19:760PM Show Hijri date …

How to convert Gregorian date to Hijri date SQL Server 2012 Read More »