Problem with Reading a specific table from SQL Server by mssql in javascript ('dbo.index')

Question

I have to read a table named dbo.Index from SQL Server in my node js express app but it fails and returns nothing.

Here's my code:

app.get('/getData',  (req, res, next) => {
    const config = {
        user: 'sa',
        password: '12345',
        server: 'localhost',
        database: 'myDB'
    }
    const pool = new sql.ConnectionPool(config)

    pool.connect(err => {
        if (err) console.log(err)
        console.log('connected.')

        const request = new sql.Request(pool)
        request.query(`SELECT * FROM dbo.Index`, (error, recordSet) => {
            if (err) console.log(error)
            res.send(recordSet)
        })
    })

})

I've tested this code and it works well with other tables but with this specific name dbo.Index, it fails.

It's necessary for me to read it and I can't change the table name (have no permission).

I use node-mssql package in order to connect to the database.

Diado · Accepted Answer · 2020-06-17 12:24:14Z

1

INDEX is a Reserved word, so you will need to wrap it in square parentheses, like so:

SELECT * FROM [dbo].[Index]

It's generally best to try and avoid using reserved words for table or column names as it easily leads to confusion, mistakes and bugs.

edited Jun 17, 2020 at 12:24

answered Jun 17, 2020 at 7:51

Diado

2,2583 gold badges22 silver badges22 bronze badges

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

Collectives™ on Stack Overflow

Problem with Reading a specific table from SQL Server by mssql in javascript ('dbo.index')

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related