求助：SQL代码出现Msg156与Msg102语法错误，请求排查解决

Hey there, let's work through these two syntax errors you're hitting with your SQL code. I'll break down each issue and walk through common fixes to get your query running smoothly.

Error 1: Msg 156 (Keyword 'INTO' near syntax error) #

This error almost always ties to a misused SELECT INTO statement. Here's what to check on line 12:

• Incorrect placement of INTO: The INTO clause needs to sit right after your selected columns, before the FROM clause. A valid SELECT INTO (used to create a new table and populate it in one step) looks like this:

  SELECT Column1, Column2
  INTO NewTargetTable
  FROM SourceTable
  WHERE [YourFilterConditions]
  

• Confusing SELECT INTO with INSERT INTO: If you're trying to add data to an existing table (not create a new one), you need to use the INSERT INTO ... SELECT ... pattern instead:

  INSERT INTO ExistingTable (Column1, Column2)
  SELECT Column1, Column2
  FROM SourceTable
  WHERE [YourFilterConditions]
  

Double-check that you're using the right approach for your use case, and that there are no typos or missing commas in the column list before the INTO keyword.

Error 2: Msg 102 (Syntax error near 'LocationID') #

This error means SQL can't parse the code leading up to LocationID on line 24. Common issues to look for:

• A missing comma before LocationID (if it's part of a column list)
• Unclosed parentheses, quotes, or brackets earlier in the query
• A misspelled keyword or invalid alias right before LocationID
• A missing FROM clause or invalid table reference if LocationID is being called without a source table

For example, if you have something like this, the missing comma between columns will break the parser when it reaches LocationID:

SELECT CustomerName, OrderDate LocationID

Next Steps #

If you can share the full code around lines 10-14 and 22-26, we can pinpoint the exact issue even faster. But even with the snippet provided, starting with these checks should help you resolve these syntax blockers.

内容的提问来源于stack exchange，提问作者NewToSQL