Dynamic Table Name on Select Into

  • Comments posted to this topic are about the item Dynamic Table Name on Select Into

  • Not sure if I have a place for this anywhere right now. But I do enjoy reading other people's code looking for ideas. Thanks.

  • Could this be adapted to copy data to a separate database in the same instance. We perform mostly database to database copying.

    Example:

    SELECT my-column1, my-column2

    INTO [my-2nd-database].[schema].[mytable]

    FROM [my-1st-database].[schema].[mytable]

    Cuppadan

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

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