-2

I seem to get this error message.

[Error importing data: Error in statement #1: near "S":syntax error. Aborting execution and rolling back.] (https://i.stack.imgur.com/IzRvb.png)

I looked into the SQL file. These are the first few lines:

Select * from Shippers /*

MS SQL Server Setup script for SQL Practice Problems Database: Northwind_SPP

*/

Set nocount on

GO /****** Object: Table [dbo].[Categories] ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Categories]( ...

Can't seem to find the "Syntax error" especially in line 1.

Niño Noel Perez
  • 1

2 Answers2

0

The Northwind SQL examples are for , which may have a slightly different syntax than . You won't be able to use them with an RDBMS they were not intended for.

Mureinik
  • 297,002
  • 52
  • 306
  • 350
0

Using https://github.com/jpwhite3/northwind-SQLite3 to download.

Started DBeaver.

Created connection to the download and :-

enter image description here

MikeT
  • 51,415
  • 16
  • 49
  • 68