How to split string and insert values into table in SQL Server

by

assuming your split returns column name item

insert <table> (colname)
select y.item
from dbo.SplitString(@testString, ':') x
cross apply
dbo.SplitString(x.item, ',') y

More Related Contents:

  1. Max Nbr of Months W/ No Activity in Past 12 Months
  2. SQL server query to output the data shown below
  3. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  4. How do I generate a random number for each row in a T-SQL select?
  5. Combine multiple results in a subquery into a single comma-separated value
  6. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  7. Floor a date in SQL server
  8. How to drop a table if it exists?
  9. Create a view with ORDER BY clause
  10. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  11. INSERT INTO vs SELECT INTO
  12. Possible to store value of one select column and use it for the next one?
  13. How FOR XML PATH(”) works when concatenating rows
  14. Scheduled run of stored procedure on SQL server
  15. SQL Server ORDER BY date and nulls last
  16. SQL Server variable columns name?
  17. What is the Oracle equivalent of SQL Server’s IsNull() function?
  18. How to determine the field value which can not convert to (decimal, float,int) in SQL Server
  19. How can I get the sum of multiple datetime values?
  20. Use of Begin / End Blocks and the Go keyword in SQL Server?
  21. How do you determine what SQL Tables have an identity column programmatically
  22. Ampersand (&) operator in a SQL Server WHERE Clause
  23. Avg of float inconsistency
  24. how to write number to word function in sql server [closed]
  25. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  26. “If not exists” fails on SQL CE
  27. Does the `nodes()` method keep the document order?
  28. Incorrect syntax near ‘)’ calling stored procedure with GETDATE
  29. Generate MD5 hash string with T-SQL
  30. Why can’t Entity Framework see my Stored Procedure’s column information?

Leave a Comment