INSERT INTO sql server error : invalid object name
- by thormayer
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!
