Mass Insert using Except, Sql Server

Mass Insert using Except

Language: Layout:

View schema
Execution time: 0,03 sec, rows selected: 10, rows affected: 9, absolute service time: 0,22 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
permission
record
test1
test2
test3

1
deer
_SuperUser
99
test1
test2
test3

2
dingo
_SuperUser
99
test1
test2
test3

3
dog
_SuperUser
99
test1
test2
test3

λ

                                      .NET NoSQL database for rapid development