Kilt and Code is the personal website of Steven McLintock
I'm a Scottish software developer based in Stratford, Ontario. I enjoy writing about the things I learn, primarily on the languages and frameworks I use on a daily basis. You can also read about my journey to becoming a full stack developer, immigrating to Toronto as a .NET developer and more in the archives.
Auto-Generate Insert Statements With Data Using SQL Server Management StudioBy Steven McLintock on
If you are working with a database in SQL Server Management Studio (SSMS), you may find you need a way to auto-generate INSERT statements with the data from a table. This might be for inserting the data into a different database for testing purposes, or simply as a backup. Read more
Creating a Web API Using Only the .NET CLI and Visual Studio CodeBy Steven McLintock on
Have you ever wondered if you could use the .NET CLI and Visual Studio Code to build a new .NET application, instead of relying on Visual Studio to do all of the heavy lifting? Read more
Using MERGE in SQL Server to do an INSERT or UPDATE on a TableBy Steven McLintock on
I’ve never really made much use of the MERGE statement in SQL Server, but the other day I wanted to do either an INSERT or an UPDATE on a table, depending on if there’s a match on a particular column. Read more