Run Code
|
API
|
Code Wall
|
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
20181CSE0041
string concatenation as aggregate operator in group by
MyDatabase
do several updates at once
BRYAN
DeletorWall
Testsql
Stored procedure ex1
Checking SQL Job run status
OUTER JOIN