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 »
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 »
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 »
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 »
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( »
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 »
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 »
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 »
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 »
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: »
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 »