.NET Core API – How to add data into SQL Database
In this post we will see how to add data into MS SQL Database using .NET Core API. We will create a .NET Controller to… Read More ».NET Core API – How to add data into SQL Database
sql
Create Login API using .NET Core | ASP.NET C#
In this post we will create a basic login API using .net core. This API will be using SQL database for storing user info and… Read More »Create Login API using .NET Core | ASP.NET C#
SQL Server – SELECT DISTINCT on multiple Columns
In SQL Server Select Distinct clause can be used to retrieve distinct records on a particular column or can be used on multiple columns. This… Read More »SQL Server – SELECT DISTINCT on multiple Columns
SQL Server – SELECT DISTINCT Statement
SQL Server – Using Select Distinct Statement Using Distinct statement we can retrieve distinct values from a table. Distinct eliminates all the duplicate records for… Read More »SQL Server – SELECT DISTINCT Statement
SQL Server – Using GROUP BY
SQL Server – Using GROUP BY statement: Group by statement in SQL server database groups the data into groups using column name specified in the… Read More »SQL Server – Using GROUP BY
ASP.NET – Insert data using SQL Stored Procedures
SQL stored procedures are prepared SQL queries that we can use multiple times in our applications. With combination of “if and else” statements it can… Read More »ASP.NET – Insert data using SQL Stored Procedures
Download SQL NorthWind database BAK file
You can download SQL Northwind database bak file using below link or from Github.com. On Github script for the database is present. Official Microsoft site. DOWNLOAD… Read More »Download SQL NorthWind database BAK file