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
sql
|sql-server
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