Background

We can use a user-defined table type to declare table-valued parameters for stored procedures, functions or in a batch. However, we cannot alter/modify the type once it is created. As per Microsoft

In the restriction section, it says: ‘The user-defined table type definition cannot be modified after it is created’.

But sometimes we need to modify or alter the user defined types.

This article shows how to automate the process of transforming the configuration file like App.config, Web.config file when we deploy it to the different destination environments like Dev, Stg, Prod. Most applications have settings in the App.config or Web.config file that must be different when the application is deployed. Automating the process of making these changes saves us from having to do them manually every time we deploy, which would be tedious and error prone.