Avatar of smantz
Flag for United States of America

asked on 

This query isn't working what do I do?

I'm trying to run this update statement in SQL 2000 (don't laugh) ;

Update Student set Picture = SID + ‘.jpg’

and I'm receiving the following error:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '‘'.

Do I need parentheses around SID + ‘.jpg’

Microsoft SQL ServerDatabases

Avatar of undefined
Last Comment
Pavel Celba

8/22/2022 - Mon