SQL Function to Split Comma Separated Values and Insert into Table
SQL Function to Split Comma Separated Values and Insert into Table
2010-11-30 (first published: 2010-11-07)
4,206 reads
SQL Function to Split Comma Separated Values and Insert into Table
2010-11-30 (first published: 2010-11-07)
4,206 reads
This is simple script to change string to title case. It will take string in any case and convert it to initcap.
2010-11-12 (first published: 2010-10-19)
1,515 reads
String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's string manipulation workbench, here newly revised with extra material from collaborator Phil Factor
2010-10-19
4,427 reads
How to change your "UPPER" or "lower" case strings to a mixed case
2010-10-18
6,087 reads
2010-07-20 (first published: 2010-06-23)
2,577 reads
2010-02-16
3,607 reads
Unlike other relational database management systems that shall remain nameless, SQL Server's underlying coding language, T/SQL, does not have a built-in function for padding string values. I recently took it upon myself to create my own and as you'll see I got a little carried away
2009-05-15
2,910 reads
2009-03-19 (first published: 2009-02-17)
1,437 reads
Find And Replace any string, in the entire table with this function. Parameterized for easy use.
2009-02-26 (first published: 2009-02-09)
885 reads
This artcle by new author Manie Verster examines the use of the PATINDEX function in T-SQL.
2008-09-11
10,368 reads
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
I'm trying to figure out a how to do average costing over time in...
Comments posted to this topic are about the item What is Between?
Comments posted to this topic are about the item Inside the Walls of Azure...
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers