7 January, 2019
Roel van Lisdonk
0 Comments
1 category
declare @name nvarchar(max)
=
‘test.d.f.g.hf.ddddd’
declare @items table(
id int
identity(1,1)
not
null
, part nvarchar(max)
);
insert
into @items
(part)
select [value]
from
string_split(@name,
‘.’)
where
rtrim([value])
<>
”;
select
*
from @items
This will result in:
Tags: T-SQL
Category: Uncategorized
Related Posts
How to: Convert an Image to a byte array in C#, by using a extension method.
20 December, 2011
Roel van Lisdonk
0 Comments
1 category
If you want to convert an Image to a byte…
How to redirect all output from a PowerShell script to a log file
1 October, 2021
Roel van Lisdonk
0 Comments
1 category
The PowerShell script "My-Script.ps1" is just an example.…
Unable to load VertiPaq engine in PowerPivot for Excel
21 May, 2012
Roel van Lisdonk
0 Comments
1 category
Problem Solution Installing the latest version of Microsoft SQL…