Have a backup of original data when updating data
- Language:: T-SQL
- Type:: Back-end
- Context:: When updating data for testing, keep original
- Description – Have a backup of original data when updating data. You can have this by having the field you want to update in the where clause with the original value
- Snippet
UPDATE Users SET UserID = 1, TestValue = 'mickey'
Where UserID = 2 and TestValue = 'Donald' and Id = 5- Dependencies:: – link to any other code or packages that are relevant or that you need to use this snippet