Skip to content

Commit 0449613

Browse files
authored
Updates
1 parent 386be27 commit 0449613

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/t-sql/language-elements/set-local-variable-transact-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -178,7 +178,7 @@ For more information, see [DECLARE CURSOR (Transact-SQL)](../../t-sql/la
178178

179179
You can use the compound assignment operator anywhere you have an assignment with an expression on the right-hand side of the operator, including variables, and a SET in an UPDATE, SELECT, and RECEIVE statement.
180180

181-
Don't use a variable in a SELECT statement to concatenate values (that is, to compute aggregate values). Unexpected query results may occur. Because, all expressions in the SELECT list (including assignments) aren't necessarily run exactly once for each output row. For more information, see [this KB article](https://support.microsoft.com/kb/287515).
181+
Don't use a variable in a SELECT statement to concatenate values (that is, to compute aggregate values). Unexpected query results may occur. Because, all expressions in the SELECT list (including assignments) aren't necessarily run exactly once for each output row. For more information, see [this KB article](https://www.betaarchive.com/wiki/index.php?title=Microsoft_KB_Archive/287515).
182182

183183
## Permissions
184184
Requires membership in the public role. All users can use SET **@**_local_variable_.

0 commit comments

Comments
 (0)