Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Except Insert missing
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
-- ///////////SCHEMA/////////////////////////////////////////////////// CREATE TABLE Animals ([animal] varchar(255), [legs] int, [colour] varchar(255)) ; CREATE TABLE ObjectPermissions ([animal] varchar(255), [permission] varchar(255), [record] int, [test1] varchar(255), [test2] varchar(255), [test3] varchar(255) ) ; INSERT INTO Animals ([animal], [legs], [colour]) VALUES ('cat', 4, 'red'), ('bird', 2, 'yellow'), ('dog', 4, 'red'), ('deer', 4, 'red'), ('fish', 0, 'blue'), ('dingo', 4, 'yellow') ; select * from animals -- //////////////////////////////////////////////////////////////////// DECLARE @temptable table ( animal VARCHAR(max), legs VARCHAR(max), colour VARCHAR(max) ) INSERT INTO @temptable (animal, legs, colour) VALUES ('fish' , 0, 'blue') INSERT INTO @temptable (animal, legs, colour) VALUES ('dog', 4, 'red') INSERT INTO @temptable (animal, legs, colour) VALUES ('Giraffe', 2, 'Orange') select * into #temp from @temptable insert Animals (animal, legs, colour) select animal, legs, colour from #temp except select animal, legs, colour from Animals drop table #temp; select * from animals
View schema
Execution time: 0,06 sec, rows selected: 13, rows affected: 10, absolute service time: 0,3 sec
edit mode
|
history
|
discussion
animal
legs
colour
1
cat
4
red
2
bird
2
yellow
3
dog
4
red
4
deer
4
red
5
fish
0
blue
6
dingo
4
yellow
animal
legs
colour
1
cat
4
red
2
bird
2
yellow
3
dog
4
red
4
deer
4
red
5
fish
0
blue
6
dingo
4
yellow
7
Giraffe
2
Orange