22,209
社区成员
发帖
与我相关
我的任务
分享
DECLARE @sql varchar(5000)
declare @ny varchar(200)
set @ny='201905'
set @sql='select * into #c from(select *
from opendatasource(
'''+'sqloledb'+''','''+
'data source=192.168.252.28;User ID=sa;Password=123456''
).zberp5.[000].'+@ny+'_Goods group by goodscode)c'
EXEC(@sql)