存储过程查询并插入到临时表
select * into #t from OPENROWSET(
'SQLOLEDB','SERVER=192.168.90.18;uid=sa;pwd=Mm-000000;Database=tms',
'SET FMTONLY OFF;set nocount on;exec Sys_Index_sp @ActionType=N''GetIndexSum'',@UserCode=N''HR1635''') as a
select * into #t from OPENROWSET(
'SQLOLEDB','SERVER=192.168.90.18;uid=sa;pwd=Mm-000000;Database=tms',
'SET FMTONLY OFF;set nocount on;exec Sys_Index_sp @ActionType=N''GetIndexSum'',@UserCode=N''HR1635''') as a
【推荐】还在用 ECharts 开发大屏？试试这款永久免费的开源 BI 工具！
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步