SQL Fill Factor and Performance

How to Turning a Comma Separated String into Individual Rows in SQL Server?

Last Updated : 11 Apr, 2023

Given a column in the table having strings with comma-separated values. The task is to split all the comma-separated values and insert them as new rows.

So, let’s start by creating a database first.

Step 1: Create a Database.

Query :

CREATE DATABASE GFG

Step 2: Use the GFG Database.

Query :

USE GFG

Step 3: Create a table

Create a table (CommaSeparated) to store the data.

Query :

CREATE TABLE CommaSeparated(Strings VARCHAR(20));

Output :

Step 4: Insert some data into the database.

Query :

INSERT INTO CommaSeparated
VALUES ('A,C'),
       ('B'),
       ('A,G'),
       ('C'),
       ('B');

Output :

Step 5: SQL query to split all the comma-separated values and insert them as new rows.

We can split the string using STRING_SPLIT method. Get the new rows by applying the CROSS APPLY method to this.

Query :

the  
  VALUE 
FROM 
  CommaSeparated CROSS APPLY STRING_SPLIT(Strings, ',');

Output :

SQL Fill Factor and Performance

V

vandanakillari54935

Improve

Article Tags :

Similar Reads

How to Split a Delimited String to Access Individual Items in SQL?

In SQL, dealing with delimited strings is a common task, especially when handling data that are not structured in a traditional tabular format. Whether it's parsing a list of values separated by commas or any other delimiter, splitting these strings into individual items is crucial for various data

Combine Rows into String in SQL Server

To combine rows into a string in SQL Server, use the SQL COALESCE() function or the SQL CONCAT() function. COALESCE() function in SQL is used to handle null values. It returns non-null values from a row, which can be concatenated into string. CONCAT() function in SQL is used to concatenate two or mo

How to Save Results With Headers in SQL Server Management Studio?

In this article, we will be looking at how to save results with headers in SQL server management studio. We will be first creating a table to insert data into it, and then printing the contents of the table, then we see how to save results with headers in the Microsoft SQL server management studio.

BULK INSERT in SQL Server(T-SQL command)

BULK INSERT in SQL Server(T-SQL command): In this article, we will cover bulk insert data from csv file using the T-SQL command in the SQL server and the way it is more useful and more convenient to perform such kind of operations. Let's discuss it one by one.Â ConditionSometimes there is a scenario

How to Select Group of Rows that Match All Items on a List in SQL Server?

In this article, we will see, how to select a group of rows that match all the items on a list in SQL Server. We can perform the above function by two methods. Those are: By using IN operatorBY performing JOIN using STRING_SPLIT methodIN operator: It allows you to specify a list of values in a WHERE

How to Use Reserved Words as Column Names in SQL?

In SQL, certain words are reserved. These are called Keywords or Reserved Words. These words cannot be used as identifiers i.e. as column names in SQL. But, there is an exception to this rule too. In this article, we will discuss how to use Reserved Words as column names in SQL. For this article, we

How To Find the Sum of Digits in a String in SQL Server?

Given a string with digits and characters. The task is to find the sum of digits in that string. So, let's start by creating a database first. Step 1: Create a Database. Query : CREATE DATABASE GFG Step 2: Use the GFG Database. Query : USE GFG Step 3 : Â a) Select each character as a row by traversin

How to Compare Rows and Columns in the Same Table in SQL

In SQL, comparing rows and columns in the same table is a common task for data analysis, identifying relationships, and calculating differences. By using techniques like self-joins and conditional queries, we can extract meaningful insights from a single table. This enables efficient querying, allow

How to Alter Multiple Columns at Once in SQL Server?

In SQL, sometimes we need to write a single query to update the values of all columns in a table. We will use the UPDATE keyword to achieve this. For this, we use a specific kind of query shown in the below demonstration. For this article, we will be using the Microsoft SQL Server as our database an

SQL Query to Find Shortest & Longest String From a Column of a Table

Here, we are going to see how to find the shortest and longest string from a column of a table in a database with the help of SQL queries. We will first create a database "geeks", then we create a table "friends" with "firstName", "lastName", "age" columns. Then will perform our SQL query on this ta