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

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

How to check if a column exists in the SQL Server table

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

Categories SQL Leave a comment
Older posts
Page1 Page2 Next →

Posts you may like

  • How to do Case-Insensitive String comparison in JavaScript?
  • Logger To File and Console – C# Interview Question
  • Concatenate Multiple SQL Rows Into Single String
  • What Are benefits of using REF keyword in C#?
  • How to Install Microsoft SQL Server 2019 Express Edition?
  • How to check if a column exists in the SQL Server table
  • How to Set Conditional Breakpoints in Visual Studio 2022?
  • 12 Important Things About Programming – Tips for Beginners
  • How to Comment Code in Visual Studio Code?
  • Is There a Difference Between String and string in C#?

Footer Menu

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