INSERT INTO sql server error : invalid object name

Posted by thormayer on Stack Overflow See other posts from Stack Overflow or by thormayer
Published on 2012-09-26T21:33:07Z Indexed on 2012/09/26 21:37 UTC
Read the original article Hit count: 333

Filed under:
|

I have a problem with some statement on SQL SERVER the error I get is that I have an invalid object name 'TBL_VIDEOS'

INSERT INTO TBL_VIDEOS (
  TBL_VIDEOS.ID,
  TBL_VIDEOS.TITLE,
  TBL_VIDEOS.V_DESCRIPTION,
  TBL_VIDEOS.UPLOAD_DATE,
  TBL_VIDEOS.V_VIEWS,
  TBL_VIDEOS.USERNAME,
  TBL_VIDEOS.RATING,
  TBL_VIDEOS.V_SOURCE,
  TBL_VIDEOS.FLAG
) 
VALUES 
('Z8MTRH3LmTVm',
'Why Creativity is the New Economy',
'Dr Richard Florida, one of the world's leading experts on economic competitiveness, demographic trends and cultural and technological innovation shows how developing the full human and creative capabilities of each individual, combined with institutional supports such as commercial innovation and new industry, will put us back on the path to economic and social prosperity.

Listen to the podcast of the full event including audience Q&A: http://www.thersa.org/events/audio-and-past-events/2012/why-creativity-is-the-new-economy

Our events are made possible with the support of our Fellowship. Support us by donating or applying to become a Fellow.

Donate: http://www.thersa.org/support-the-rsa
Become a Fellow: http://www.thersa.org/fellowship/apply',
CURRENT_TIMESTAMP,
0,
1,
0,
'http://www.youtube.com/watch?v=VPX7gowr2vE&feature=g-all-u'
,0)

and I wonder what i've done wrong ? (btw, the error refer to line 1.. guess its the table name.. but it correct!

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server