Azure synapse tablock

sakuraime 2,271 Reputation points
2020-06-05T16:43:32.597+00:00

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,625 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Michael 6 Reputation points
    2020-06-06T03:54:00.147+00:00

    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
    2020-06-06T06:04:49.363+00:00

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

    No comments