On 4/18/19 11:43 AM, Vikas Sharma wrote:
Hi,
I have come across a query that a developer wrote to update a few rows in
table, the query did update the two desired rows but also updated the
rest of the table with the column value as 'false'.
Update tableA set col1 = null and col2 in (1,2);
The query updated col1 to null for the rows where col2 was either 1 or 2,
rest of rows were also updated for col1 to 'false'.
The above was run without where clause.
On the QA server, right?
--
Angular momentum makes the world go 'round.
