Lesson Learned #358:Error SQL46010-contains a statement that is not supported on Azure SQL Database

Oh, we know about this:

TIP 1: Codepage will work on OpenRowset + Az DB without problem

  But you will have another problem later. Some syntax wont compile on Az Data Studio Database Project (extension), you will have an error

  This has been ACK as ahttps://github.com/microsoft/azuredatastudio/issues/22891

  OpenRowset is the Key of "Data Virtualization"  

    (No tested on Synapse Database Project, but synapse have an alternative solution)

TIP 2:  If you use codepage on OpenRowset  + FMT file, the collation must be removed from FMT file (because have preference over codepage) otherwise codepage won't be applied, and you will lost hours of tests. This is commented in the FMT but no in the Openrowset manual