🍪 Privacy & Transparency

We and our partners use cookies to Store and/or access information on a device. We and our partners use data for Personalised ads and content, ad and content measurement, audience insights and product development. An example of data being processed may be a unique identifier stored in a cookie. Some of our partners may process your data as a part of their legitimate business interest without asking for consent. To view the purposes they believe they have legitimate interest for, or to object to this data processing use the vendor list link below. The consent submitted will only be used for data processing originating from this website. If you would like to change your settings or withdraw consent at any time, the link to do so is in our privacy policy accessible from our home page..

Vendor List | Privacy Policy
Home Tags Privacy About

All posts tagged with "MSSQL"

MSSQL is a SQL relational database system developed by Microsoft

Page 1 of 3 Older Posts →

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 21 January 2023

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 21 January 2023

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

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 14 November 2022

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 14 November 2022

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 30 October 2022

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 30 October 2022

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 29 October 2022

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

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 24 October 2022

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on C#, Dapper, MSSQL 28 August 2022

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 »

Peter Daugaard Rasmussen Peter Daugaard Rasmussen on MSSQL 28 August 2022
Page 1 of 3 Older Posts →
  • Rss
  • Twitter
  • LinkedIn
  • profile for Peter Rasmussen at Stack Overflow, Q&A for professional and enthusiast programmers
Peter Daugaard Rasmussen - developer, Consultant, Blogger © 2023 Privacy policy