December 3rd, 2013
How to Use Excel to Script Database Table Updates
An easy way to set-up/prepare a database table update is to use built-in excel functionality to wrap the source data in TSQL commands.
An easy way to set-up/prepare a database table update is to use built-in excel functionality to wrap the source data in TSQL commands.