Insert multiple rows into single column

0 votes

I am having problems adding numerous data into a single column because I am new to SQL (using SQL 2008 R2).

This is what I'm trying to do with my Data table.

INSERT INTO Data ( Col1 ) VALUES
('Hello', 'World')

This question's code was used to create it, however I only want to use one column instead of two, as is the case with many other examples I've discovered online. Why am I misusing this?

Sep 4 in Database by Kithuzzz
• 12,240 points
42 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
1 answer

Inserting multiple rows in a single SQL query?

In SQL Server 2008, multiple rows can ...READ MORE

answered Feb 10 in Database by Vaani
• 7,020 points
91 views
0 votes
1 answer

Excel - Combine multiple columns into one column

In Excel, how can I concatenate (combine) ...READ MORE

answered Mar 30 in Database by gaurav
• 18,960 points
414 views
0 votes
1 answer

Excel - how to calculate sum of multiple rows into different columns

The AutoSum button or formula can be ...READ MORE

answered Apr 4 in Database by Edureka
• 13,640 points
2,364 views
0 votes
1 answer

Can I have multiple primary keys in a single table?

A Table can have a Composite Primary Key which ...READ MORE

answered Oct 25, 2018 in Database by Frankie
• 9,830 points
2,525 views
0 votes
1 answer

How to insert date values into table?

You have to convert the literal to ...READ MORE

answered Feb 18 in Database by Vaani
• 7,020 points
196 views
0 votes
1 answer

Insert into ... values ( SELECT ... FROM ... )

Try: INSERT INTO tableA ( column_1 ) SELECT ...READ MORE

answered Feb 23 in Database by Neha
• 8,920 points
304 views
0 votes
1 answer

How to delete duplicate rows in SQL Server?

To answer your query, note that CTEs ...READ MORE

answered Feb 10 in Others by Soham
• 9,330 points
196 views
0 votes
1 answer

Rename column SQL Server 2008

Use sp_rename EXEC sp_RENAME 'TableName.PreviousColumnName' , 'NewColumnName', 'COLUMN' See: SQL SERVER ...READ MORE

answered Feb 23 in Database by Vaani
• 7,020 points
53 views
0 votes
0 answers

How to update Identity Column in SQL Server?

With 200 records currently, I want to ...READ MORE

Aug 9 in Database by Kithuzzz
• 12,240 points
174 views
0 votes
0 answers

Query to check index on a table

I want a query to see if ...READ MORE

Aug 11 in Database by Kithuzzz
• 12,240 points
32 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP