Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
string conversion
declare @f varchar(255); set @f='toolbox/matlab/cefclient/+matlab/+internal/getOpenPort.p>getOpenPort'+'/'; With rcte as ( select 0 n,@f str, patindex('%[@+>]%',@f) p union all select p, substring(str, p+1,255), patindex('%[@+>]%',substring(str, p+1,255)) from rcte where p>0 ) SELECT STUFF((SELECT '.' +LEFT(str,charindex('/',str)-1) FROM rcte WHERE n>0 FOR XML PATH('')), 1, 1, '') short
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Tbl
MSQL in 10 mn ~ Lesson 9 Performing Mathematical Calculations - orderitems ~ expanded_price
megha
BRYAN
sql-server-storing-wildcards-in-data
SS Sqlsvr2014 practice
Primary key and unique key for single column and multi columns
bc160402152
Sql varchar to date
M0413045.sql
Please log in to post a comment.