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 - 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 - 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 »
MSSQL - How to drop and create a stored procedure with parameters
This post describes how to create and drop a stored procedure with a parameter in MSSQL. If we have the following MyEntities table with an Id »
MSSQL - ALTER TABLE only allows new columns which are nullable or have a DEFAULT value specified
If you are on this page you likely got an error like the following: Msg 4901, Level 16, State 1, Line 8 ALTER TABLE only allows »