MSSQL - What are aggregate functions in SQL?
When working with databases, managing and analyzing large amounts of data efficiently is crucial. This is where SQL (Structured Query Language) comes into play, SQL provides »
MSSQL - How to do casting or conversion in SQL
In Microsoft SQL Server, you can use the CAST or CONVERT function to change the data type of a value or expression. The basic syntax for »
MSSQL - How to add to a date or time in MSSQL
In SQL Server, you can use the DATEADD function to add a specified time interval to a given date. The syntax for the DATEADD function is »
MSSQL - Create a stored procedure with parameters
This post describes how to create a stored procedure in MSSQL that takes parameters. For this we will use the simple table below: CREATE TABLE SomeTable( »
MSSQL - How to use variables in SQL statements
This post will demonstrate how to SELECT from a MSSQL table using a variable. There will be three examples: * Simple select statement * Setting a variable from »
MSSQL - Creating a table with an auto increment Primary key or adding it later
In MSSQL you can set auto increment for a column using the IDENTITY property. This will often be used on the primary key column, but it »
MSSQL - SELECT Date in a specific format (yyyy-MM-dd, MM/dd/yy, MM-dd/yyyy etc.)
In MSSQL you can easily format datetime strings using the FORMAT function. For the examples in this post we will use a simple table like the »
MSSQL - Having a SELECT statement in a WHERE clause or part of SELECT statement (using subqueries)
For this blog post we will use the following two tables as examples, the scripts are written in SQL for MSSQL but it should be transferable »
How to add a column in Microsoft SQL server
The examples in this post are for MSSQL (Microsoft SQL server) but they will likely work with most other databases. If we have the following Table: »
C# Dapper - How to call a stored procedure with a parameter
This post shows you how to call a stored procedure with a parameter using Dapper. If we have the following table with an Id (int) and »