tags:

views:

36

answers:

1

How to create a dynamic SQL statement, that will update any table given as one of parameter. Here I believe, i couldn't use "Set Column1 = Value ....." as the columns will differ according to the table.

A: 

Generally speaking, you can query information schema for column names, but I don't think that would give you much since you won't know the exact values for each column.

Anton Gogolev