Showing posts with label How to insert different comma separated values into different columns in SQL Server?. Show all posts
Showing posts with label How to insert different comma separated values into different columns in SQL Server?. Show all posts

How to insert different comma separated values into different columns in SQL Server?

Step 1: Create a table in which we will insert the CSV Data using the below query:CREATE TABLE Test_Table(col1 NVARCHAR(200), col2 NVARCHAR(200), col3 NVARCHAR(200),col4 NVARCHAR(200),col5 NVARCHAR(200))Step 2: Create an SP that will break the CSV string into columns and insert the

Read More