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
archu
ms sql 3
Pivot unpivot
Insert multiple parent-child records
FIRST DATABASE
Arun
Using pre-built schema in sql server
QUAN LY CHUYEN BAY
RBT QA
SCHOOL-BUILD