add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
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_13793723856d45668d6cd33c7c309ad0", 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