Just The Programming Blog
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 will concatenate CityName column into a single string, separating each city with a comma. This is what the table of …
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 a day of the week. I highlighted in red the values that should be obtained in our sample. To solve …
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 you may need to use Microsoft.Extensions.Logging.Debug package. This package allows you to turn on debug logging. You just need to …
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 table IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MySuperFunction]’) AND type IN ( N’FN’, N’IF’, N’TF’, N’FS’, N’FT’ …
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 smooth and not lock tables for too long. Since the data does not come from files(usually CSV) it means I …
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 exists Example Let’s check if the ‘DateOfBirth‘ column exists in the ‘dbo.Person‘ table. As you can see from the screenshot …
In short: Open SQL Configuration Manager Check SQL Server State is ‘Running’ Open SQL Server Management Studio (SSMS) Use your Server Name and Windows Authentication 1. Open SQL Configuration Manager 2.Check SQL Server State is ‘Running’ “SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network …
MS SQL Express is a free database server for learning and building small web and desktop applications. Here you will be guided on how to perform a new SQL Server 2019 Express Edition installation on a Windows 10. Follow these simple steps. 1. Download ‘SQL Server Installer for Express Editions’ Download URL https://www.microsoft.com/en-gb/download/details.aspx?id=101064 The name …