Incorrect syntax in SQL Server query

Question

CREATE TABLE identity (
    empid VARCHAR(255) PRIMARY KEY,
    entry VARCHAR(255)
);

-- Table: vectors
CREATE TABLE vectors (
    f_id   INTEGER PRIMARY KEY IDENTITY(1,1),
    label  STRING  NOT NULL,
    empid  STRING  REFERENCES identity (empid) 
                   NOT NULL,
    vector BLOB    NOT NULL
);

I tried to run the above query but it gives me error

Incorrect syntax near expected '.', ID or QUOTED_ID.

I don't understand why it is giving me this error, is it because IDENTITY is a keyword in SQL Server. Kindly help!

This is all information which is available in the official documentation, which you should consult before posted here. — Dale K
– Dale K, Commented Nov 16, 2022 at 8:00

gotqn · Accepted Answer · 2022-11-16 06:36:13Z

2

Try this:

CREATE TABLE [identity] (
    empid VARCHAR(255) PRIMARY KEY,
    entry VARCHAR(255)
);


-- Table: vectors
CREATE TABLE vectors (
    f_id   INTEGER PRIMARY KEY IDENTITY(1,1),
    label  VARCHAR(255)  NOT NULL,
    empid  VARCHAR(255)  REFERENCES [identity] (empid) 
                   NOT NULL,
    vector VARCHAR(255)    NOT NULL
);

Also, if you are working with SQL Server Management Studio, you can see that some words are colored in blue. It will be better to avoid them using in your code as names of tables, variables and other objects. For example, identity is such word.

answered Nov 16, 2022 at 6:36

gotqn

44k47 gold badges167 silver badges257 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mr. Fractals Over a year ago

alright thanks a lot! also would you happen to know a way to migrate data from sqllite to sql server?

gotqn Over a year ago

There are various ways to import data in SQL Server. For example - learn.microsoft.com/en-us/sql/tools/… or hevodata.com/learn/sqlite-to-sql-server

Collectives™ on Stack Overflow

Incorrect syntax in SQL Server query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related