locked
Issue with T-SQL query RRS feed

  • Question

  • The following query was taken from the following link

    https://docs.microsoft.com/en-us/learn/modules/design-azure-sql-data-warehouse/3-azure-synapse-analytics-features

    CREATE WORKLOAD GROUP group_name  
    WITH  
    (       
        MIN_PERCENTAGE_RESOURCE = value   
      , CAP_PERCENTAGE_RESOURCE = value 
      , REQUEST_MIN_RESOURCE_GRANT_PERCENT = value
      [ [ , ] REQUEST_MAX_RESOURCE_GRANT_PERCENT = value ]  
      [ [ , ] IMPORTANCE = {LOW | BELOW_NORMAL | NORMAL | ABOVE_NORMAL | HIGH} ]
      [ [ , ] QUERY_EXECUTION_TIMEOUT_SEC = value ]  
     )[ ; ]

    When I run this T-SQL on SQL server I get the following error:

    Incorrect syntax near 'MIN_PERCENTAGE_RESOURCE'.

    Can someone let me know if the problem is because I'm trying to run the T-SQL code on SQL server when it needs to be run on a different platform?

    Cheers


    carlton

    Wednesday, May 6, 2020 8:51 PM

Answers