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