Add data for unknown name columns

[UtLinh]

I have a table with a lot of columns (and I don't know exactly names of these columns). How can I add data (data is calculated via function) for these columns using only index_col?

[Delerna]

Don't understand how you can know the index of the columns you want to calculate and not be able to find out what its name is, but anyway.

You can't with in SQL server as far as I am aware
You can SELECT * FROM TableName but you need to know the field names to perform calculations

You could do it with a scripting language connecting the various data objects
to your SQL server
and executing SELECT * FROM TableName query into a recordset object

then you can use things like
Variable=rst.fields(5)-rst.fields(7)
where rst is the recordset object with the retrieved data

Does that help???

[UtLinh]

Don't understand how you can know the index of the columns you want to calculate and not be able to find out what its name is, but anyway.

You can't with in SQL server as far as I am aware
You can SELECT * FROM TableName but you need to know the field names to perform calculations

You could do it with a scripting language connecting the various data objects
to your SQL server
and executing SELECT * FROM TableName query into a recordset object

then you can use things like
Variable=rst.fields(5)-rst.fields(7)
where rst is the recordset object with the retrieved data

Does that help???

I said incorrectly. In fact I want to use column_id
My detail task is:
+ I have table T1 with columns: c1, c2, c3, c4, c5, ..., cN.
+ c1, c2 have some data.
+ I need to calculate c3 = func(c1, c2, 'c3'), c4 = func(c1, c2, 'c4') ...

If I know name of c4 (for example: nameC4), then I can write
update T1
set T1.nameC4 = func(c1, c2, 'nameC4')

It was good if I could write:
update T1
set T1.[col_name(T1_id, 4)] = func(c1, c2, col_name(T1_id, 4))

because in the example c4 has col_id = 4. And in all cases I need to add data for all of columns except c1, c2 (I've known their col_id = 1, 2)
But write as I wanted is incorrect.

If it's your task how will you do?
Thanks for your attention

[ck9663]

I said incorrectly. In fact I want to use column_id
My detail task is:
+ I have table T1 with columns: c1, c2, c3, c4, c5, ..., cN.
+ c1, c2 have some data.
+ I need to calculate c3 = func(c1, c2, 'c3'), c4 = func(c1, c2, 'c4') ...

If I know name of c4 (for example: nameC4), then I can write
update T1
set T1.nameC4 = func(c1, c2, 'nameC4')

It was good if I could write:
update T1
set T1.[col_name(T1_id, 4)] = func(c1, c2, col_name(T1_id, 4))

because in the example c4 has col_id = 4. And in all cases I need to add data for all of columns except c1, c2 (I've known their col_id = 1, 2)
But write as I wanted is incorrect.

If it's your task how will you do?
Thanks for your attention

if you don't really know the name of the column, how would you know you're using the right column? are you basing it in position?

-- CK

[Delerna]

OK
+ I have table T1 with columns: c1, c2, c3, c4, c5, ..., cN.
+ c1, c2 have some data.
+ I need to calculate c3 = func(c1, c2, 'c3'), c4 = func(c1, c2, 'c4') ...

Not completely understanding what you mean by c3 = func(c1, c2, 'c3')
What is the calculation the func is carrying out and why is c3 in the parameters???

Anyway I think you are trying to update c3,c4,c5,....,cn in table t1 with a calculation based on C1 and C2.....is that correct???

Here is query to do above
Update T1 set C3=C1+C2,C4=C2/C1,.... etc
Where FieldName=Condition

the Where clause is optional if you only want to affect certain rows


I may be way off what you are after here but I hope it helps

[UtLinh]

OK
+ I have table T1 with columns: c1, c2, c3, c4, c5, ..., cN.
+ c1, c2 have some data.
+ I need to calculate c3 = func(c1, c2, 'c3'), c4 = func(c1, c2, 'c4') ...

Not completely understanding what you mean by c3 = func(c1, c2, 'c3')
What is the calculation the func is carrying out and why is c3 in the parameters???

Anyway I think you are trying to update c3,c4,c5,....,cn in table t1 with a calculation based on C1 and C2.....is that correct???

Here is query to do above
Update T1 set C3=C1+C2,C4=C2/C1,.... etc
Where FieldName=Condition

the Where clause is optional if you only want to affect certain rows


I may be way off what you are after here but I hope it helps

My function funct(c1,c2, 'c3') is:

select count(...)
from TableX
where TableX.v1 = c1 and TableX.v2 = c2 and TableX.v3 = 'c3'
// I use column-name as value


See your query:

Update T1 set C3=C1+C2,C4=C2/C1,.... etc
Where FieldName=Condition

+ Your query will be used only if we know column-name C3
+ I need to update all columns, not one c3.

[Delerna]

Oh, are you trying to pass the name of the field to be updated to the function???

So you can say to the function "Update This field"
now "Update this other field"
etc
If so youre talking dynamic sql