Skip to content

Full Stack Developer Blog

Just The Programming Blog

  • C#
  • Visual Studio
  • SQL
  • jQuery
  • Misc

SQL

How to Generate SQL Scripts for Previous Versions of MS SQL?

There are situations when you need to generate SQL scripts for earlier versions of the database server. For example, you may have 2019 installed in a development environment and 2014 installed in a production environment. … Read more

Categories SQL Leave a comment

How to Create a Database Schema in MS SQL?

In a database, the schema is the structure that defines the organization of data. It describes the database objects, such as tables, views, stored procedures, indexes, triggers, and functions, and how they relate to one … Read more

Categories SQL Leave a comment

Delete Duplicate Rows in Table without Primary Key

In the previous article, I showed a way how to delete duplicate rows when Primary Key exists in the table. Now I want to demonstrate how to do the same thing but in case the … Read more

Categories SQL Leave a comment

How to Remove Duplicate Rows in MS SQL Server

If there are duplicate rows in MS SQL Server database tables, it may be necessary to remove duplicate records. Let’s look at an example where duplicates are all records that have duplicate First Name, Last … Read more

Categories SQL Leave a comment

Create a Quick Copy of a Table and Place it in the Same Database

Sometimes you need a situation to quickly create a copy of an existing table in MSSQL Server. For example, you have a table named Person and you need to copy it to a table named … Read more

Categories SQL Leave a comment

Concatenate Multiple SQL Rows Into Single String

A few days ago, I needed to concatenate multiple rows into a single line of text. This was necessary to build a report. And I want to show you three ways to do it. We … Read more

Categories SQL Leave a comment

How to Find Maximum of Multiple Columns? MS SQL

Today I want to share an interesting example that describes . Here is a filled table that contains the weekly sales report: It is necessary to find the . In our case, each column is … Read more

Categories SQL Leave a comment

How to view the SQL generated by the Entity Framework Core? Enable Sensitive Data Logging

Install package Add for DbContextOptions: Turn on Sensitive data for DbContextOptions: For those using Entity Framework Core, if you want to view the output SQL with sensitive data(parameter values) in the Visual Studio output window … Read more

Categories C#, SQL Leave a comment

How to check if a function exists in a SQL database?

If you need to know if a function exists in the database(MS SQL) so that I can drop it and re-create it, you can use one of the following options: 1. Check using the sys.objects … Read more

Categories SQL Leave a comment

How Smoothly Insert Millions of Rows in SQL Server?

A few years ago, I needed to insert about rows into a table. The data to be inserted is a combination of two tables. And it’s important to note that I want it to be … Read more

Categories SQL Leave a comment
Older posts
Page1 Page2 Next →

Posts you may like

  • How To Select Multiple Records using the List of Id’s with LINQ? Entity Framework
  • How to view the SQL generated by the Entity Framework Core? Enable Sensitive Data Logging
  • How To Generate C# class from XML?
  • jQuery – How to Get a Value of an Element by Name?
  • How to Get Connection String from Appsettings.json? .net Core Console Application

Footer Menu

  • Privacy Policy
  • Contact me
  • About
  • Disclosures
  • Write Us a Guest Post
© 2023 Full Stack Developer Blog