存储过程查询并插入到临时表

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

posted @ 2017-05-12 13:15  恋之呓  阅读(1202)  评论(0编辑  收藏  举报