Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Error in Update

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-02-13 : 10:41:54
Hello,

Could someone tell me what is the error I am doing here?

UPDATE dbo.DocumentsRatings
SET
DocumentRating = @DocumentRating,
WHERE (DocumentId = @DocumentId AND UserId = @UserId)

I get an error on last code line?

Thanks,
Miguel

Kristen
Test

22859 Posts

Posted - 2007-02-13 : 10:47:14
Remove the comma on the end of

DocumentRating = @DocumentRating,

Kristen
Go to Top of Page

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-02-13 : 10:54:47
Thanks,

It is working fine now.

Miguel
Go to Top of Page
   

- Advertisement -