declare @s varchar(1000)
select @s = 'DLDATA70111'
select @s = '(SELECT SAN_ID,MAX(SAN_TIME) AS SAN_TIME FROM '+@s+'.DBO.SANDAT GROUP BY SAN_ID) C'
--下面的Data1:要连接的库名, table1:要连接的表名
select @s ='select t.* from Data1.dbo.table1 a,' +@s + ' where a.san_id= t.san_id'
把下面的语句中的DLDATA70111改成动态的名称,我好笨笨,你们都给出答案了我还不会
(SELECT SAN_ID,MAX(SAN_TIME) AS SAN_TIME FROM DLDATA70111.DBO.SANDAT GROUP BY SAN_ID)C
我不要立刻执行结果,不要带EXEC,我要把他作为一个表和其他表连接