Possible to set servername, database and table at runtime?

[MarkMarkov]

Is is possible to set the servername, database and table at runtime and then do a select using that setting? In other words, something like:

declare @r varchar
set @r = "server.databasename.dbo.table"
select * from @r

 

[fredericofonseca]

This is the ANSI SQL forum, not the SQL SERVER forum.


You can do that easily with Dinamyc SQL, but not with Stored Procedures in Transact-SQL (which is used by SQL Server and Sybase).

You can also do it with Oracle in PL/SQL.

But as many others have said before using dinamic tables on SP´s is not a good move. If you just need to change the database, then you can use something like.

@db = 'MyDB'

EXEC (@db + '.dbo.DeleteUserByMasterId @ID = ' + @ID)





Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com