for a my Synapse Analytics solution I've a dedicated SQL pool and I need to feed some tables with few row data (10-15-20 rows). I've already used the INSERT ... VALUES statement, but repeating this instruction in a complete manner (for SQL Server I can write the INSERT keyword only one time).
Does it exist a more quick/efficient manner to solve a such issue? Thanks