lundi 18 mai 2015

Insert query not working with select query

I need to copy a row from a database table to another database table. I used this query,

insert into db_target.dbo.table_name(column_names)
  values(select * from db_source.dbo.table_name);

But it is not being copied!

Aucun commentaire:

Enregistrer un commentaire