Em Andamento

help with SQL query

i have an ms-access database i'm using to collect data for an experiment and i want to update several of the tables in the database.

each table has around 100 columns and i'd like to write some type of query which will update each column, except the first 5 which are common to all the tables. i'd like all the remaining columns to be initialized to 0.

what i'm looking for is some kind of sql programming code chunk that would end up having the same results as this type of more traditional code.

for each row in table data

for each column

if column not in [key, date, time] then

set column = 0

end if

next

next

another option would be to code it something like this...

for each row in table data

for column_num = 5 to numofcolumns

set column = 0

next

next

i want the query generalized so that it can be used on any table, so that i do not have to specify the column names, but can just say for every row, start at the 6th column, update each with 0 for all the remaining columns of that row or i can specify column names to ignore since all the tables will have similar named columns which will be ignored.

i have attached an example ms-access table, the first 5 columns should not be updated, but all the rest should be.

## Deliverables

THE EXAMPLE TABLE IS NAMED "DATA" AND IN LOCATED INSIDE THE MS-ACCESS DATABASE 4P1

Habilidades: Engenharia, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software

Ver mais: programming sql, programming in sql, named query, i want all key programming, database programming sql, common query, what is ms sql, ms project help, ms access sql, write query, SQL Query, sql programming, query table, data query, access query table, update code sql, access table query, php sql update, access sql query, sql query access, update sql code, help access code, query project data, sql query help, update rest table

Acerca do Empregador:
( 48 comentários ) East Lansing, United States

ID do Projeto: #3032247

Premiar a:

vnb400sl

See private message.

$17 USD em 3 dias
(109 Avaliações)
5.7

13 freelancers are bidding on average $12 for this job

NeoNoXtraOrdnry

See private message.

$12.75 USD in 3 dias
(81 Comentários)
5.5
seventhsensesl

See private message.

$8.5 USD in 3 dias
(66 Comentários)
4.9
rshyethmusthafa

See private message.

$8.5 USD in 3 dias
(27 Comentários)
4.7
sproutsystemsvw

See private message.

$11.9 USD in 3 dias
(36 Comentários)
4.4
ioanaprof

See private message.

$8.5 USD in 3 dias
(27 Comentários)
4.3
smb310570

See private message.

$17 USD in 3 dias
(17 Comentários)
3.7
ftsolutionsvw

See private message.

$17 USD in 3 dias
(2 Comentários)
2.5
DesignStudio60

See private message.

$12.75 USD in 3 dias
(5 Comentários)
1.4
berkaysvw

See private message.

$7.65 USD in 3 dias
(0 Comentários)
0.0
rajnsuvw

See private message.

$12.75 USD in 3 dias
(1 Comentário)
0.0
amrtolbavw

See private message.

$8.5 USD in 3 dias
(0 Comentários)
0.0
guruforU

See private message.

$17 USD in 3 dias
(0 Comentários)
0.0