Help needed...

• saurabh.punn

  SSC Enthusiast

  Points: 181

  More actions

  July 9, 2008 at 5:57 am

  #193688

  hi all

  i have a simple query.

  how can i copy a table from the "master" database to the "pubs" database?

  thanks in advance

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  July 9, 2008 at 6:37 am

  #840049

  Can be done using SELECT INTO

  Example:

  use pubs

  go

  select * into dbo.Trial from master.dbo.Trial