declare @TTable char(20) --数据表
declare @TDatabase char(20) --数据库
declare @SourceDatabase char(40)
set @TTable='..DBtable'
set @TDatabase='DBData'
set @SourceDatabase=rtrim(ltrim(@TDatabase))+rtrim(ltrim(@TTable))
exec('select * from '+@SourceDatabase)
declare @TDatabase char(20) --数据库
declare @SourceDatabase char(40)
set @TTable='..DBtable'
set @TDatabase='DBData'
set @SourceDatabase=rtrim(ltrim(@TDatabase))+rtrim(ltrim(@TTable))
exec('select * from '+@SourceDatabase)
[交流]动态SQL语句
declare @TTable char(20) --数据表
declare @TDatabase char(20) --数据库
declare @SourceDatabase char(40)
set @TTable='..DBtable'
set @TDatabase='DBData'
set @SourceDatabase=rtrim(ltrim(@TDatabase))+rtrim(ltrim(@TTable))
exec('select * from '+@SourceDatabase)
declare @TDatabase char(20) --数据库
declare @SourceDatabase char(40)
set @TTable='..DBtable'
set @TDatabase='DBData'
set @SourceDatabase=rtrim(ltrim(@TDatabase))+rtrim(ltrim(@TTable))
exec('select * from '+@SourceDatabase)