Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Script to Copy multiple fields to another in one table 2

Status
Not open for further replies.

Fampofo

Programmer
May 24, 2002
16
GB
Hi Guys,
How do you write a script to copy all values from one column to another column.
For example I have two columns EnquiryDate and ActionDate in a table. The ActionDate is have Null values at the moment. I would like to copy dates in each of the enquiryDate field to its corresponding actionDate field.
help would be appreciated
 

update table
set ActionDate = EnquiryDate


RT
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top