No row was updated
The data in row 2 was not committed.
Error Message: The row values(s) updated or deleted either do not make the row unique or they alter multiple rows(2 rows).
Hi There, I am trying to update the date column for one of the column and getting the above error. When we edit the column in SSMS we can modify only one column at a time as more than one column is unique it is not finishing successfully.
Workaround is to use Update table statement.
Make sure you use select statement to check the number of records your update statement is going to modify.
BEGIN TRAN
update [dbo].[TestRates]
set Conversion_Date='2018-03-04' where ToCurrency='AUD'
and Conversion_Date is null
ROLLBACK TRAN
COMMIT TRAN
The data in row 2 was not committed.
Error Message: The row values(s) updated or deleted either do not make the row unique or they alter multiple rows(2 rows).
Hi There, I am trying to update the date column for one of the column and getting the above error. When we edit the column in SSMS we can modify only one column at a time as more than one column is unique it is not finishing successfully.
Workaround is to use Update table statement.
Make sure you use select statement to check the number of records your update statement is going to modify.
BEGIN TRAN
update [dbo].[TestRates]
set Conversion_Date='2018-03-04' where ToCurrency='AUD'
and Conversion_Date is null
ROLLBACK TRAN
COMMIT TRAN
2 comments:
The Top Rated Babaylon T-Shirt - Classic Sports
› brasyliss-mini-tinte titanium hair trimmer › brasyliss-mini-tinte The top Rated micro titanium trim Babaylon T-Shirt · · · · titanium drill bits for metal · · · · does titanium have nickel in it · · · · · · · · · · · · · 2018 ford ecosport titanium ·. · ·. · · ·. ·. ·. ·. ·. ·. ·. ·..
az767 michaelkorsportugal,all star zapatillas,alo yoga brasil,allstarschweiz,michael kors lentes,moonbootskaufenschweiz,michael kors tasche,dope suusajope,veja נעליים ut511
Post a Comment