Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MarkyBoy666
Starting Member
14 Posts |
 Posted - 2006-05-03 : 04:00:09
|
| Does anyone know if, in an Update or Insert query within a DDQ task, it's possible to have more than one statement in the query, and have them both execute? e.g. update tablex set field1=1 where id=? update tablex set field2 = 2 where id=? Also, on the same subject, can you mix the statements, so let's say even if it's the Update query you're using, could you tag an insert on the end as well? e.g. update tablex set field1=1 where id=? insert into tablex (field2) values (?) Thanks for any help. |
|
|
|
|
|
DDQ - Update/Insert Queries