search

JamesPattison / RepoLite

A tool used for generating lightweight, fast repositories against database tables with standard CRUD functionality & additional merge & bulk actions
MIT License
5 stars 2 forks source link

Merge statement - change to temp with optional collation #2

Open JamesPattison opened 5 years ago

JamesPattison commented 5 years ago

At the moment the merge statement created a staging table for bulk loading to before the merge takes place.

We need to change this to use a #temp table, however we also then need to be able to specify the DB collation since MGB reminded me it's created in tempdb so has the default collation

JamesPattison commented 5 years ago

As an aside for later, get the current collation using SELECT SERVERPROPERTY ('Collation')

May or may not be useful...