Azure-docs: Confusion about assigning variable by select within declare statement

[SmallTomas]

Hi,

I think there is some confusion in the documentation about the assignment of variables by select within declaration.

First it is written here it is not possible, but in next examples the assignment by select is used when showing other limitations.

So I would like to ask, is it possible to assign variable by select within declare statement? Thanks.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: ab05fc5d-5c42-9a53-50c4-b8c936ddb5dc
• Version Independent ID: e6799ec5-508f-ee3c-08e6-4e186031510d
• Content: Assign variables - Azure Synapse Analytics
• Content Source: articles/synapse-analytics/sql-data-warehouse/sql-data-warehouse-develop-variable-assignment.md
• Service: synapse-analytics
• Sub-service: **
• GitHub Login: @XiaoyuMSFT
• Microsoft Alias: xiaoyul

[MartinJaffer-MSFT]

Thank you for your detailed feedback. We are looking into the issue, and we will respond when we have more information.

[MartinJaffer-MSFT]

Thank you for bringing this to our attention, @SmallTomas .

I believe what it means to say is "You cannot use DECLARE inside a SELECT statement or inside an UPDATE statement. Also, UPDATE cannot be used to change the variable value.

I base this idea on three points:

1. I was able to execute the code snippet in question
2. There is a select inside the example, but not update inside the example
3. Placing a DECLARE statement inside a SELECT statement does not make sense, especially given the latter point that one variable cannot refer to another variable inside the same DECLARE statement.

I will assign this to the author @XiaoyuMSFT for clarification and correction.

[XiaoyuMSFT]

@SmallTomas - Thank you for your feedback. The last code example should be changed to:

DECLARE @p1 int = 0;
DECLARE @p2 int = (SELECT COUNT (*) FROM sys.types where is_user_defined = @p1 );

[XiaoyuMSFT]

please-close