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!

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

updating columns

Status
Not open for further replies.
bluebytez

bluebytez

Programmer
Dec 20, 2001
39
MY
hi, i am trying to update 30 columns in a table but it's a hassle typing all the 30 column names in the update statement, is there a way to loop thru the column names ? the column names are col001 ... col030
thanks for the effort !
 
Sort by date Sort by votes
iv'e just scripted out the table and the copied the filed names back into to the procedure. no very efficient, but at 3am and it has to be done before 5 ... it has saved me from some typoes here and there.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How can I update the input of a form (rows and columns) to the database in one query ?
Replies
1
Views
414
Chris Miller
Chris Miller
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
444
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Determine Table Columns Associated with View Columns
Replies
4
Views
246
iambob
iambob
malaygal
  • Locked
  • Question
Pivot rows into columns
Replies
1
Views
181
dhookom
dhookom
Santysri1976
  • Locked
  • Question
Updating value from last entered value
Replies
1
Views
186
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top