Usually, I will add an optional parameter and use that as an indicator. Here is an example.
Let’s say you are adding a field in the Customers table called TwitterId and your latest app version is using this field. Let’s also say you have a Customers_Insert stored procedure that is used to store new records into the db. Your current SP would look like this:
Create Procedure dbo.Customer_Insert (
Insert Into Customers(CustomerName)
Now, you can change the stored procedure to this:
Alter Procedure dbo.Customer_Insert(
@TwitterId varchar(50) = ‘<not passed>’)
Insert Into Customers(CustomerName, TwitterId)
Values (@CustomerName, @TwitterId)
The new version of your app will pass a @TwitterId parameter; your old one will not, thus the value will be ‘<not passed>’.
Hope this helps.