Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
how-to-assign-a-random-value-in-a-select-statement-in-sqlserver
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
/* Much better: https://stackoverflow.com/questions/50402873/how-to-assign-a-random-value-in-a-select-statement-in-sql SELECT T1.COL1, (SELECT TOP 1 t2.COL2 FROM T2 where t1.col1 is not null ORDER BY NEWID() ) FROM T1 */ WITH RANDOM_COLUMNS AS ( SELECT name as col_name ,NEWID() as uuid FROM sys.columns ), ENUMERATED_COLUMNS AS( SELECT ROW_NUMBER() over (order by uuid) as c_id ,col_name ,col_uuid = uuid FROM RANDOM_COLUMNS ), RANDOM_TABLES AS ( SELECT t_id = ROW_NUMBER() OVER (ORDER BY name) ,name as table_name FROM sys.tables T ) SELECT * FROM RANDOM_TABLES T JOIN ENUMERATED_COLUMNS C ON T.t_id = C.c_id
View schema
Execution time: 0,03 sec, rows selected: 4, rows affected: 0, absolute service time: 0,19 sec
edit mode
|
history
|
discussion
t_id
table_name
c_id
col_name
col_uuid
1
1
Flights
1
filestate
2aaa6ba7-6b26-46a0-9804-002183bc865d
2
2
Pilots
2
Birth_date
bbf6f127-180a-4b2a-9755-005eb824bc8e
3
3
Pilots_on_flights
3
on_success_step_id
31107276-2b0f-4563-a4b4-00b5307bc48c
4
4
Planes
4
step_id
268679bc-bed9-47b8-afad-00bf778da248