Returning only updated fields from database <p>I'm building stored procedure which will be used by my Web API application. Now, I have multiple databases and multiple stored procedures which returns me all data which is specified by API contract. What I want to do is to customize my SP's in the way that they are going to return me only updated rows. E.g. I have 10 columns in a table, and user changes 2 columns, stored procedure check which columns are affected and returns me only those and for all other columns it should return null. So far I was thinking to create new table which will store <code>ProductId</code> and <code>UpdatedFields</code> so when update SP is triggered, it will update Name and Category fields and store those column names in new table under <code>UpdatedFields</code> like comma separated strings (<code>Name</code>, <code>Category</code>...) and on retrieving member data SP will not return <code>Price</code> nor <code>Quantity</code> (those should be null) but just <code>Name</code> and <code>Category</code>.</p> <p>Any help is appreciated.</p>