Error in simple SQL update query

Question

My Table structure is like this

    CREATE TABLE [dbo].[tdnResetTickets](
    [ResetID] [int] IDENTITY(1,1) NOT NULL,
    [userName] [varchar](200) NULL,
    [tokenHash] [nvarchar](200) NULL,
    [expirationDate] [datetime] NULL,
    [tokenUsed] [bit] NULL,
    [tokenType] [bit] NULL,
 CONSTRAINT [PK_tdnResetTickets] PRIMARY KEY CLUSTERED 
(
    [ResetID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

And I want to update a column in that table. My query is like this

UPDATE [dbo].[tdnResetTicket] SET [tokenUsed] = 0  WHERE ResetID =1

And it throws an error

    Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.tdnResetTicket'.

Can anyone point out what I am doing wrong here?

Are you selecting the right database?

RdPC
– RdPC

2016-12-13 07:48:44 +00:00
Commented Dec 13, 2016 at 7:48 — RdPC
– RdPC, Commented Dec 13, 2016 at 7:48

Chanukya · Accepted Answer · 2016-12-13 07:49:57Z

2

UPDATE [dbo].[tdnResetTickets] SET [tokenUsed] = 0  WHERE ResetID =1

The Table is tdnResetTickets with s and Update Query is tdnResetTicket

answered Dec 13, 2016 at 7:49

Chanukya

5,8911 gold badge24 silver badges39 bronze badges

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

Comments

ahmed abdelqader · Accepted Answer · 2016-12-13 07:48:49Z

2

The Table is tdnResetTickets with s and Update Query is tdnResetTicket

Correct Code:

UPDATE [dbo].[tdnResetTickets] SET [tokenUsed] = 0  WHERE ResetID =1

answered Dec 13, 2016 at 7:48

ahmed abdelqader

3,58220 silver badges38 bronze badges

Comments

mkl · Accepted Answer · 2016-12-13 08:46:46Z

-1

Table name is incorrect in update statement.

UPDATE [dbo].[tdnResetTickets] SET [tokenUsed] = 0 WHERE ResetID =1

edited Dec 13, 2016 at 8:46

mkl

97k17 gold badges144 silver badges302 bronze badges

answered Dec 13, 2016 at 7:49

Red Devil

2,4135 gold badges30 silver badges46 bronze badges

2 Comments

AFract Over a year ago

This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. - From Review

Red Devil Over a year ago

UPDATE [dbo].[tdnResetTickets] SET [tokenUsed] = 0 WHERE ResetID =1

Collectives™ on Stack Overflow

Error in simple SQL update query

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related