By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
24 rows affected
Msg 547 Level 16 State 0 Line 2
The INSERT statement conflicted with the CHECK constraint "FriendsAreDistinct_CK". The conflict occurred in database "fiddle_4acce214015746d2833c953f8d6022a4", table "dbo.Friendship".
Msg 3621 Level 0 State 0 Line 2
The statement has been terminated.
RequesterId | AddresseeId | SpecifiedDateTime | CurrentStatusCode | SpecifierId |
---|---|---|---|---|
1750 | 1748 | 2016-04-02 11:02:06.000 | B | 1748 |
CurrentStatusCode |
---|
B |
StatusCode | Name |
---|---|
A | Accepted |
B | Blocked |
D | Declined |
R | Requested |
UserId | FullName |
---|---|
4247 | Alan Kay |
1750 | Alan Turing |
1748 | Frank Codd |
3691 | Grace Hopper |
1825 | Konrad Zuse |
5342 | Margaret Hamilton |
RequesterId | AddresseeId | SpecifiedDateTime | CurrentStatusCode | SpecifierId |
---|---|---|---|---|
1750 | 1748 | 2016-04-01 16:58:12.000 | R | 1750 |
1750 | 1748 | 2016-04-02 09:13:08.000 | A | 1748 |
1750 | 1748 | 2016-04-02 11:02:06.000 | B | 1748 |
1825 | 4247 | 2016-05-11 16:28:03.000 | R | 1825 |
1825 | 4247 | 2016-05-11 19:18:09.000 | A | 4247 |
1748 | 5342 | 2016-06-11 11:13:05.000 | R | 1748 |
1748 | 5342 | 2016-06-12 19:03:07.000 | D | 5342 |
3691 | 1750 | 2016-06-20 16:28:05.000 | R | 3691 |
3691 | 1750 | 2016-06-20 16:51:10.000 | A | 1750 |
3691 | 1750 | 2016-06-21 08:05:05.000 | B | 1750 |
RequesterId | RequesterFullName | AddresseeId | AddresseeFullName | CurrentStatusCode | SpecifiedDateTime | SpecifierId |
---|---|---|---|---|---|---|
1748 | Frank Codd | 5342 | Margaret Hamilton | R | 2016-06-11 11:13:05.000 | 1748 |
1748 | Frank Codd | 5342 | Margaret Hamilton | D | 2016-06-12 19:03:07.000 | 5342 |
1750 | Alan Turing | 1748 | Frank Codd | R | 2016-04-01 16:58:12.000 | 1750 |
1750 | Alan Turing | 1748 | Frank Codd | A | 2016-04-02 09:13:08.000 | 1748 |
1750 | Alan Turing | 1748 | Frank Codd | B | 2016-04-02 11:02:06.000 | 1748 |
1825 | Konrad Zuse | 4247 | Alan Kay | R | 2016-05-11 16:28:03.000 | 1825 |
1825 | Konrad Zuse | 4247 | Alan Kay | A | 2016-05-11 19:18:09.000 | 4247 |
3691 | Grace Hopper | 1750 | Alan Turing | R | 2016-06-20 16:28:05.000 | 3691 |
3691 | Grace Hopper | 1750 | Alan Turing | A | 2016-06-20 16:51:10.000 | 1750 |
3691 | Grace Hopper | 1750 | Alan Turing | B | 2016-06-21 08:05:05.000 | 1750 |
RequesterId | AddresseeId | SpecifiedDateTime | CurrentStatusCode | SpecifierId |
---|---|---|---|---|
1750 | 1748 | 2016-04-02 11:02:06.000 | B | 1748 |
1750 | 1748 | 2016-04-02 09:13:08.000 | A | 1748 |
1750 | 1748 | 2016-04-01 16:58:12.000 | R | 1750 |