Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQLERROR
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
CREATE TABLE [dbo].[Table1]( [id] uniqueidentifier NOT NULL , [id2] uniqueidentifier NOT NULL, [name] nvarchar(max) NOT NULL CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED ( [id] ASC )) GO CREATE NONCLUSTERED INDEX [IX_Table2_ID2] ON [dbo].[Table1] ( [id2] ASC ) ALTER TABLE [dbo].[Table1] ADD CONSTRAINT [DF_Id] DEFAULT (newsequentialid()) FOR [id] GO CREATE TABLE [dbo].[Table2]( [id] uniqueidentifier NOT NULL, [name] varchar(10) CONSTRAINT [PK_Table2] PRIMARY KEY CLUSTERED ( [id] ASC )) GO ALTER TABLE [dbo].[Table2] ADD CONSTRAINT [DF_Id2] DEFAULT (newsequentialid()) FOR [id] Declare @loop int = 1 while @loop<=10 begin insert into Table2 ([name]) Values(char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65))) set @loop = @loop+1 end set @loop = 1 while @loop<2000 begin insert into Table1 (ID2, [name]) select ID,char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65))+char((rand()*25 + 65)) from Table2 set @loop = @loop+1 end select top 100 table1.Name,table2.Name from table1 WITH (NOLOCK) left join table2 on table1.ID2= table2.ID order by table2.ID desc,table1.ID desc
View schema
Execution time: 1,92 sec, rows selected: 20211, rows affected: 20009, absolute service time: 2,49 sec
fork mode
|
history
|
discussion
Name
Name
1
DHFM
RWDR
2
VEMA
SDJK
3
WYYG
BHMA
4
HWJH
WUOQ
5
LLSI
RWDR
6
TIGJ
UXQG
7
XHNF
XGPW
8
TGGF
XGPW
9
SLDV
UXQG
10
GGSR
LFKS
11
BXLB
DDHH
12
YIXP
LFKS
13
AHPF
RWDR
14
NVGM
SDJK
15
HNEP
XGPW
16
VKKP
ABJD
17
MJUW
BHMA
18
YCDC
RWDR
19
UNXF
SDJK
20
JCWX
ABJD
21
UTPN
BHMA
22
QTAB
DDHH
23
AOLL
ABJD
24
CRPX
BHMA
25
OYFT
LFKS
26
NHAK
BHMA
27
GNRW
RWDR
28
GJST
SDJK
29
JKLC
UXQG
30
YEQP
RWDR
31
MDES
XVOX
32
WACY
WUOQ
33
WRQP
DDHH
34
LPHY
WUOQ
35
BHOD
SDJK
36
IXHA
WUOQ
37
GWBB
DDHH
38
VUXO
BHMA
39
SJWS
RWDR
40
JYIV
ABJD
41
QNNH
UXQG
42
QYMB
SDJK
43
BTBB
LFKS
44
UTYX
ABJD
45
YTJD
DDHH
46
HBES
LFKS
47
UEMX
SDJK
48
HKBL
DDHH
49
VBJN
DDHH
50
QIWG
WUOQ
51
NVEB
RWDR
52
GLUV
XGPW
53
VFOR
WUOQ
54
CMGF
WUOQ
55
PIPW
LFKS
56
ESCA
DDHH
57
ASWL
LFKS
58
NKAS
UXQG
59
PLVF
SDJK
60
WAXV
XGPW
61
GGJF
SDJK
62
RGDC
XGPW
63
ASAQ
UXQG
64
JLAH
LFKS
65
YAGE
XGPW
66
QAHS
XVOX
67
JKXH
ABJD
68
JNHY
SDJK
69
NFCR
RWDR
70
VYJA
RWDR
71
QFKR
XVOX
72
JIDD
XGPW
73
SQUL
XVOX
74
BOJB
WUOQ
75
KXOP
XGPW
76
TCDF
DDHH
77
NQWJ
SDJK
78
EBXV
ABJD
79
QQIU
WUOQ
80
RVUJ
ABJD
81
IUCL
BHMA
82
DYVU
DDHH
83
UTCX
BHMA
84
UQJS
LFKS
85
HSCG
BHMA
86
IFDV
ABJD
87
PRNA
XVOX
88
MDFR
SDJK
89
JCUY
SDJK
90
EDOQ
XVOX
91
PFMN
XGPW
92
PMJL
XGPW
93
EYJC
RWDR
94
HDAN
DDHH
95
XWGS
ABJD
96
LUSF
XVOX
97
FYNH
UXQG
98
AHAR
ABJD
99
QDTV
RWDR
100
DNWS
SDJK
Name
Name
1
DHFM
RWDR
2
VEMA
SDJK
3
WYYG
BHMA
4
HWJH
WUOQ
5
LLSI
RWDR
6
TIGJ
UXQG
7
XHNF
XGPW
8
TGGF
XGPW
9
SLDV
UXQG
10
GGSR
LFKS
11
BXLB
DDHH
12
YIXP
LFKS
13
AHPF
RWDR
14
NVGM
SDJK
15
HNEP
XGPW
16
VKKP
ABJD
17
MJUW
BHMA
18
YCDC
RWDR
19
UNXF
SDJK
20
JCWX
ABJD
21
UTPN
BHMA
22
QTAB
DDHH
23
AOLL
ABJD
24
CRPX
BHMA
25
OYFT
LFKS
26
NHAK
BHMA
27
GNRW
RWDR
28
GJST
SDJK
29
JKLC
UXQG
30
YEQP
RWDR
31
MDES
XVOX
32
WACY
WUOQ
33
WRQP
DDHH
34
LPHY
WUOQ
35
BHOD
SDJK
36
IXHA
WUOQ
37
GWBB
DDHH
38
VUXO
BHMA
39
SJWS
RWDR
40
JYIV
ABJD
41
QNNH
UXQG
42
QYMB
SDJK
43
BTBB
LFKS
44
UTYX
ABJD
45
YTJD
DDHH
46
HBES
LFKS
47
UEMX
SDJK
48
HKBL
DDHH
49
VBJN
DDHH
50
QIWG
WUOQ
51
NVEB
RWDR
52
GLUV
XGPW
53
VFOR
WUOQ
54
CMGF
WUOQ
55
PIPW
LFKS
56
ESCA
DDHH
57
ASWL
LFKS
58
NKAS
UXQG
59
PLVF
SDJK
60
WAXV
XGPW
61
GGJF
SDJK
62
RGDC
XGPW
63
ASAQ
UXQG
64
JLAH
LFKS
65
YAGE
XGPW
66
QAHS
XVOX
67
JKXH
ABJD
68
JNHY
SDJK
69
NFCR
RWDR
70
VYJA
RWDR
71
QFKR
XVOX
72
JIDD
XGPW
73
SQUL
XVOX
74
BOJB
WUOQ
75
KXOP
XGPW
76
TCDF
DDHH
77
NQWJ
SDJK
78
EBXV
ABJD
79
QQIU
WUOQ
80
RVUJ
ABJD
81
IUCL
BHMA
82
DYVU
DDHH
83
UTCX
BHMA
84
UQJS
LFKS
85
HSCG
BHMA
86
IFDV
ABJD
87
PRNA
XVOX
88
MDFR
SDJK
89
JCUY
SDJK
90
EDOQ
XVOX
91
PFMN
XGPW
92
PMJL
XGPW
93
EYJC
RWDR
94
HDAN
DDHH
95
XWGS
ABJD
96
LUSF
XVOX
97
FYNH
UXQG
98
AHAR
ABJD
99
QDTV
RWDR
100
DNWS
SDJK