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

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

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

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

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

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

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

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

There are three common ways to check if column exists in the table Check column in the SYS.COLUMNS Check column in the INFORMATION_SCHEMA.COLUMNS Use COL_LENGTH function You can use any of these methods. Check Column … Read more