Post reply

Help needed...

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply