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 »
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 »
C# Dapper - How to execute a select statement using a list of Ids with an IN clause in MSSQL
Using Dapper you can easily map results of a query to an object or a list of objects. Sometimes you want to select a list of »