we have database project and im using some partitions on tables, when I build the solution I am getting below error :
In VS 2012 with latest SSDT and Target platform: "Microsoft Azure SQL Database V12" I get this error :
"SQL46010: Incorrect syntax near (. " and its mark bracket between "WITH ( PARTITIONS"
Actual Syntax used in one of my SP is TRUNCATE TABLE PartitionTable1 WITH (PARTITIONS (2, 4, 6 TO 8));
Please let me know if anyone faced this issue and any resolution or workaround.