Home Menu
  • Home
  • About – Tomas Lind
  • Contact
  • Blog Series
    • Technical Analysis (TA)
  • T-SQL
    • T-SQL Scripts
    • Templates
  • Consulting Services
  • Software
Tomas Lind

Posts in Category ‘Excel’

  • 2017/07/18
  • 4 comments

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 →

  • Posted in: Excel, T-SQL
  • 2013/12/26
  • 104 comments

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 →

  • Posted in: Excel

confided data manager

Get compliant with the GDPR!


High Coast Database Solutions

High Coast Database Solutions

sql server consulting services


Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Top Posts & Pages

  • How to align columns in Notepad++
  • Manual failover in a SQL Server cluster
  • Export data from Excel to SQL Server
  • List SQL server roles by users
  • CDC Cleanup job

Recent Posts

  • Get element max value from folder with XML files
  • Dynamic Data Masking (DDM) – Mask query results
  • The T-SQL Merge statement
  • From SQL Server to MSMQ using PowerShell
  • Identity columns that are about to overflow

Archives

Categories

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Instagram

This error message is only visible to WordPress admins

Error: No connected account.

Please go to the Instagram Feed settings page to connect an account.

  • © 2022 Tomas Lind
  • Proudly powered by WordPress
  • Theme: Waipoua by Elmastudio
Top ↑