By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
roleId | roleFields |
---|---|
1 | dataField1,dataField2,dataField3,dataField4 |
2 | dataField1,dataField2 |
3 | dataField1,dataField3,dataField4 |
upd | clm | whr |
---|---|---|
update myTable set | dataField1=@dataField1 | null |
null | dataField2=@dataField2 | null |
null | dataField3=@dataField3 | null |
null | dataField4=@dataField4 | where roleId=1 |
update myTable set | dataField1=@dataField1 | null |
null | dataField2=@dataField2 | where roleId=2 |
update myTable set | dataField1=@dataField1 | null |
null | dataField3=@dataField3 | null |
null | dataField4=@dataField4 | where roleId=3 |
sqlString |
---|
update myTable set dataField1=@dataField1 |
dataField2=@dataField2 |
dataField3=@dataField3 |
dataField4=@dataField4where roleId=1 |
update myTable set dataField1=@dataField1 |
dataField2=@dataField2where roleId=2 |
update myTable set dataField1=@dataField1 |
dataField3=@dataField3 |
dataField4=@dataField4where roleId=3 |