Member Avatar for Fenerbahce

Hi,

i have 2 tables. i have 3 equal colomns in both. I want transfer all data from 1st table to another one. How can i do it?

Thanks

this doesn't work but something like this;

insert into exam (e_score, l_name, s_id)
values (dbo.assignment.e_score, dbo.assignment.l_name, dbo.assignment.s_id)

  • 2 Contributors
  • 1 Reply
  • 103 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by eralper
Member Avatar for eralper

Hi,
You can use the below syntax:

insert into ... select

The exact sql is as follows:

insert into exam (e_score, l_name, s_id)
select e_score, l_name, s_id from assignment

Eralper
http://www.kodyaz.com

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.