The T-SQL Merge statement
You have a table A with new data, and a table B with old data. How do you make sure table B is refreshed with data from table A? You want to insert new records, update existing records and to … Read more →
Posts in Category ‘Excel’
Export data from Excel to SQL Server
Need to get data from Excel to SQL Server? Normally this can be achieved by using SSIS. Excel can be used as a source and/or target in a Data flow. But there may be situations where you need more granular … Read more →