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…
How to Change Visual Studio Theme? Change to Dark Theme
The Visual Studio allows changing themes. The default theme is “Blue”, let’s switch it to the “Dark” theme. To change the theme in Visual Studio…
How to use localeCompare() in JavaScript?
The localeCompare() method is a built-in JavaScript function that compares two strings in a case-sensitive or case-insensitive manner, based on the current locale. It returns…
How to do Case-Insensitive String comparison in JavaScript?
The simplest method for comparing strings without considering case in JavaScript is to convert both strings to either lowercase or uppercase using the toLowerCase() or…
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,…
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 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…
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…
How to check String contains a Substring in JavaScript?
There are two popular ways to check string contains a substring in JavaScript: includes() and indexOf(). The includes() method The ECMAScript 6 specification has String.prototype.includes…
Generate C# Class From JSON in Visual Studio
Using Visual Studio 2012 or newer you can just “Special Paste” your JSON as C# classes. Steps to Generate C# Class from JSON Copy your…
What is ChatGPT and Can it Replace a Programmer?
ChatGPT is an artificial intelligence(AI) platform that allows you to ask a question and gives you an answer. ChatGPT is an AI chatbot trained to…
How To Display Suggestion Menu with USINGS in Visual Studio?
The keyboard-shortcut that shows the suggestion menu with the necessary using statement is Ctrl – . or Alt – Shift – F10. The using statement…
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…
How to Sort a List by a property in the object?
There are two quick ways to sort List<T> based on the property of the complex C# object. For example, let’s sort this person list by…
Top-level statements must precede namespace and type declarations
A few days ago I wanted to create a simple C# Console Application. And faced with the error: “error cs8803: Top-level statements must precede namespace…