Msg 141, Level 15, State 1, Line 3
A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.
This error message appears when you try to assign a value to a variable in combination with a data-retrieval operation in a SELECT statement.
The SQL statement cannot be parsed and further execution is stopped.
Error of the severity level 15 are generated by the user and can be fixed by the SQL Server user.
All versions of SQL Server.
DECLARE @orderID INT
SET @orderID = 10289
SELECT @orderID = OrderID, *
WHERE OrderID = 10289
The above example tries to assign the value of the column OrderID to the variable @orderID per SELECT statement. At the same time the SELECT statement tries to return all column for OrderID = 10289. This combination triggers the error.