Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
SQL Server : Add max(column_value)+1 when NULL
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
--Sql Server 2014 Express Edition --Batches are separated by 'go' IF OBJECT_ID('dbo.Test2', 'U') IS NOT NULL DROP TABLE dbo.Test2; IF OBJECT_ID('dbo.Test3', 'U') IS NOT NULL DROP TABLE dbo.Test3; Create table Test2 ( ColumnID int ); Create table Test3 ( ColumnID int ); INSERT INTO Test2 values(1); INSERT INTO Test2 values(2); INSERT INTO Test2 values(3); INSERT INTO Test2 values(5); INSERT INTO Test2 values(8); INSERT INTO Test2 values(null); INSERT INTO Test2 values(null); INSERT INTO Test2 values(null); INSERT INTO Test2 values(null); INSERT INTO Test2 values(null); INSERT INTO Test3 SELECT COALESCE(ColumnID, ROW_NUMBER() OVER (PARTITION By ColumnID ORDER BY ColumnID) + MAX(ColumnID) OVER ()) FROM Test2 SELECT * FROM Test3 ORDER BY ColumnID DROP TABLE Test2; DROP TABLE Test3;
View schema
Execution time: 0,02 sec, rows selected: 10, rows affected: 20, absolute service time: 0,17 sec
edit mode
|
history
ColumnID
1
1
2
2
3
3
4
5
5
8
6
9
7
10
8
11
9
12
10
13