By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
13 rows affected
1 rows affected
ConfigName | Revision | IsDeployed | IsCurrent | Names |
---|---|---|---|---|
config_foo | 1 | False | False | other.name,some.name |
config_foo | 2 | True | True | other.name,revised.name,third.name |
config_bar | 1 | False | False | other.name,some.name,unique.name |
Msg 2601 Level 14 State 1 Line 2
Cannot insert duplicate key row in object 'dbo.PublicNames' with unique index 'UQ dbo.PublicNames Unique Current Public Names'. The duplicate key value is (other.name).
Msg 3621 Level 0 State 0 Line 2
The statement has been terminated.