Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
MixT
declare @mix nvarchar(max)=N'Смартфон DEXP Ixion ES135 Hit White 6901'; with l0 as( select 1 c union all select 1 ),l1 as( select a.c from l0 a,l0 b ),l2 as( select a.c from l1 a,l1 b ),l3 as( select a.c from l2 a,l2 b ),l4 as( select a.c from l3 a,l3 b ),nm as( select row_number()over(order by(select null)) n from l4 a,l4 b order by n offset 0 rows fetch first len(@mix) rows only ),up as( select n,substring(@mix,n,1) c from nm ) select (select c+'' from up where lower(c) between N'a' and N'z' order by n for xml path('')) ln;
run
|
edit
|
history
|
help
0
Task2
Recursive cte (common table expression)
pk
La Project
Cinema latinoamericano
#Temp table Collation fixed
tFuncionario
DDL,DQL,DML
Week 6 Data Base IET
stackoverflow_mysql_demo_data