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 |
|
davidliv
Starting Member
45 Posts |
 Posted - 2003-12-10 : 14:02:06
|
| Using the following query:INSERT INTO myTable1 SELECT myFld1, myFld2, myFld3 FROM myTable1 WHERE myID = '1'I'm able to copy a row into a new record. Is it possible to also change the value of "myFld2" within the same query?-david |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-12-10 : 14:04:43
|
| Change it to what?INSERT INTO myTable1 SELECT myFld1, 'Other Value' AS myFld2, myFld3 FROM myTable1 WHERE myID = '1'Brett8-) |
 |
|
|
|
|
|
Copy row & changing one value of that row