Posted by amfi1 on 01/25/06 22:41

Hi

My problem is as follows:

I need to transmit data between two databases on the same server, but I
have to use dynamic database names (they must be configurable). For
example I need to achive sth like that:

insert into [database1].[dbo].[table1]
(select columns from [table2])

when database1 is not known at implementation stage.

I know I can use EXEC @t_sql_code, but I wonder if there is any other
way? (OPENROWSET doesn't seem to suit my needs)

Thanks in advance

Amfi

• Next in forum: Re: ASC Result Set with Nulls at the bottom
• Prev in forum: ASC Result Set with Nulls at the bottom
• Thread view: Insert/Update with dynamic database name

[Reply to this message]