Error Message:

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword ‘INTO’.

This error occurs when the syntax of the select into statement is not correct.

Product INTO ProductBackup

When the above code is executed error message 156 would occur.


– Check the SELECT INTO syntax.
– Make sure that the INTO Statement is after the column list( or *) and before FROM.

Fixed Code:
SELECT * INTO ProductBackup
FROM Product

Leave a Reply

Your email address will not be published. Required fields are marked *