Azure synapse tablock

sakuraime 2,281 Reputation points

Dear All expert.
In Azure sql datawarehouse. are there any way to do tablock ?

I have a table with a column having an id int column .
I want to insert a record in this table with increment of 1 . how can I do that ?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,832 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Michael 6 Reputation points

    it's a bit pain point for me right now ~really don't know the reason that it doesn't include in DW . as well as the foreign key ………………………...

  2. Michael 6 Reputation points

    Hi. thanks . for data modelling (from DW) , I still need the "unique key" so to relate the tables ….