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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2008-01-03 : 09:31:54
|
| I have a SQL table and a field called SpecReq. I want to copy the contents of SpecReq in each record to another field in the record called MeetTitle.Can I do this with an update query or do I need to use Analyser ? Also what is the syntax please |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-01-03 : 09:35:27
|
| UPDATE YourTableSET MeetTitle=SpecReq |
 |
|
|
Pinto
Aged Yak Warrior
590 Posts |
Posted - 2008-01-03 : 09:41:59
|
Thanks - yes I had that but got the error string or binary data would be truncated.Just found that my MeetTitle was 200 char and my SpecReq 2000Thanks. It's ok now |
|
|
|
|
|
|
Copy contents of one field to another