Archives for Database
Hackerrank: SQL Query to get Customer Name who made max order in 10 years
Hackerrank is one of the top websites that help us to test our skills in different areas like C#, SQL, JAVA. Following is the SQL Query asked at Hackerrank. Problem…
Working with Default Parameters in SQL Server Functions
As in any programming language, we can even set the default parameters for the Functions and Procedures on SQL Server. But calling these functions or procedures will differ with how we…
Calling REST API Service From SQL Server Using C# SQL CLR
Problem Statement A requirement where we need to get a data from other sources (REST-based Web Service) and sync with on-premises (local) database. This should be done using a SQL…
Problem with ASP.NET using MySQL Connecting through ODBC Driver in some Hosting Servers
Recently I hosted one of my application which is using MySQL as backend and I decided to use MySQL .NET connector to access the MySQL server. I hosted one of the…