≡ Menu

SQL Server

Converting T-SQL for MS Access SQL Queries

I’m moving to pastures new and will be leaving behind a well-loved SQL Server database, complete with a rich array of patient level data. At my new job I will likely have to make do with an Access database and so I’ve been doing a bit of preparation, building a quick cheat sheet so I [...]

{ 1 comment }

Importing CSV files to an SQL Server Database

Importing CSV files to an SQL Server Database Thumbnail

I regularly need to set up new tables in my SQL Server Database from data held externally as either text or csv. It sounds like an incredibly straightforward task but always sends me scurrying off to google for advice on How to Import CSV to SQL Server. It doesn’t help that I don’t have access [...]

{ 0 comments }