People cannot read your mind, so post your code and clear specs if you really want help.
If the WHERE clause contains a primary key expression, the UPDATE statement changes one row only.
If you omit the WHERE clause, the same modification will be applied to every row in the table.
OR is it that, sql allows only UPDATEs with one set of values to n rows. e.g insert into TABLE1 select column1, column2, column3 from TABLE2 This is perfectly valid, assumes TABLE1 has only three columns, column1, column2, column3.
Hi, Does SQL support update to multiple rows where values coming from a sub-query?
However, in some cases, we have to use triggers and it is important to develop them correctly.
SQL Server fires triggers on statement rather than row level.
HGGOI I would like to create an update statement to put update these values into 5 diffrent rows ?
according to your specs, this is what you need: update whoknowsset col1 = 'MMADAS', col2 = 'HHFASD', col3 = 'HGGOI' where row ID in (1,2,3,4,5):-) ______________________________________________________________________________How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
My question: Is there any way to UPDATE values to TABLE1 similarly?