 | |
Update question
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Update question -
10-02-2004
, 02:33 AM
#2
| |||
| |||
|
|
Hi All If I need to update sevel fields on all recordes in a table how would go about doing that with one update sentence - is that possible ? Or do I have to make an update statement for each field...? --Michael V. |
#3
| |||
| |||
|
|
Update tblX Set Field1 = val1, Field2 = val2, Field3 = val3.... "Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote in message news:%23VfCEFFqEHA.2636 (AT) TK2MSFTNGP09 (DOT) phx.gbl... Hi All If I need to update sevel fields on all recordes in a table how would go about doing that with one update sentence - is that possible ? Or do I have to make an update statement for each field...? --Michael V. |
#4
| |||
| |||
|
|
Ouch....is that possible....thanks a lot... "Law" <lawrencedcoder (AT) hotmail (DOT) com> skrev i en meddelelse news:eOBS1IFqEHA.644 (AT) tk2msftngp13 (DOT) phx.gbl... Update tblX Set Field1 = val1, Field2 = val2, Field3 = val3.... "Michael Vardinghus" <michaelvardinghus (AT) notexisting (DOT) com> wrote in message news:%23VfCEFFqEHA.2636 (AT) TK2MSFTNGP09 (DOT) phx.gbl... Hi All If I need to update sevel fields on all recordes in a table how would go about doing that with one update sentence - is that possible ? Or do I have to make an update statement for each field...? --Michael V. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.