Msg 194, Level 15, State 1, Line 2
A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.
This error message appears when you try to assign a value to a variable within a SELECT INTO 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. You cannot assign a value to a variable within a SELECT INTO statement.
All versions of SQL Server.
DECLARE @OrderID INT
SELECT *, @OrderID = OrderID
WHERE CustomerID LIKE ‘B%’
In the above example we try to assign a value to the variable @OrderID in a SELECT INTO statement. This raises the error.