Solved

How do I create an update statement from columns that are numbers?

Posted on 2011-02-23
3
314 Views
Last Modified: 2012-05-11
I have a table (inherited I hasten to add!) which has numbers as column names. How would I write this statement where 40 is a column and 37 is a column?

Update import set 40 = 37 where barcode = '117454-04123'

Thanks
0
Comment
Question by:suroma
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 34959511
Update import set [40] = [37] where barcode = '117454-04123'
0
 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 250 total points
ID: 34959515
Update import set [40] = [37] where barcode = '117454-04123'

Open in new window

0
 
LVL 8

Expert Comment

by:vinurajr
ID: 34959533
you can use like this [40]  ... for columns 40
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now