Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Seq
with a as( select N'АБВГДЕЁЖЗИЙКЛМНОПРСТУФХЦЧШЩЪЫЬЭЮЯ' c, N'0123456789' d ),b as( select c,d, abs(checksum(newid()))%len(c)+1 c1, abs(checksum(newid()))%len(d)+1 d1, abs(checksum(newid()))%len(c)+1 c2, abs(checksum(newid()))%len(d)+1 d2 from a ),c as( select substring(c,c1,1)+ substring(d,d1,1)+ substring(c,c2,1)+ substring(d,d2,1) p from b ),d as( select a.p+'-'+b.p+'-'+c.p+'-'+d.p s from c a,c b,c c,c d ) select s from d,master..spt_values
run
|
edit
|
history
|
help
0
CTE reqursive query
Window Functions - ROW_NUMBER()
Sql Question 1
Using pre-built schema in sql server
Sql Server sys.syslanguages
mi
SQL_Joins_Intersect_Except_Union
Mass Insert using Except
Trabalho.Agrecação
New