Insert multiple rows Access SQL

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

Other Forums

MS Access

Insert multiple rows Access SQL

Author

Topic

mdixon44
Starting Member

26 Posts

Posted - 2008-12-19 : 11:17:05

I need help with the table creation below.. As you see that I have created the table. The confusion that I am having is adding the information to the table. I know that using the insert into the SONG_TB table. I have tried and failed at this, I need some assistance with this.

Create a table, named Song_tb, include the following column names: song_id, song_name, prfmr_name, and song_duration.

create table SONG_TB
(song_id varchar(3),
song_name varchar(20),
prfmr_name varchar(20),
song_duration varchar(4));

mdixon44
Starting Member

26 Posts

Posted - 2008-12-19 : 11:53:19

This is my failed attempt..

INSERT INTO SONG_TB
VALUES ('201','Just Like Me','Jamie Foxx','03:26');
INSERT INTO SONG_TB
VALUES ('202','ifuleave [Feat. Mary J. Blige]', 'Musiq Soulchild', '03:54');
INSERT INTO SONG_TB
VALUES ('203',"I'm Sprung",'T-Pain','03:44');
INSERT INTO SONG_TB
VALUES ('204','Touch My Body', 'Mariah Carey', '03:45');
INSERT INTO SONG_TB
VALUES ('205', 'Umbrella [Feat. Jay-Z]','Rihanna', '04:36');
COMMIT;

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-19 : 12:33:55

What error are you getting?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

mdixon44
Starting Member

26 Posts

Posted - 2008-12-19 : 12:37:33

Thank you Tara for responding

The error is Characters found after the end of SQL statement

then is shows the cursor on the end of the first statement.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources