Tag Archives: Line 214 Incorrect syntax near ‘merge’. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of

Merge Statement for a SQL Server 2000 compatible Database

I have recently been asked if we can write a Merge T-sql to handle inserts and updates in the same statement for a Database on SQL Server 2008 at SQL 2000 compatibility level. The answer is YES and NO; I … Continue reading

Posted in SQL Server, T-SQL Scripts | Tagged , , , , , , | 3 Comments