Dynamic Table Name on Select Into

Question

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

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 1

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.

Cuppadan SSC Enthusiast Points: 109 More actions · Answer 2

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

Cookies on SQLServerCentral