• 125721

    文章

  • 803

    评论

  • 12

    友链

  • 最近新加了换肤功能,大家多来逛逛吧~~~~
  • 喜欢这个网站的朋友可以加一下QQ群,我们一起交流技术。

将存储过程的结果插入临时表 - Insert results of a stored procedure into a temporary table

服了这份高薪指南,涨多少你说了算>>

问题:

How do I do a SELECT * INTO [temp table] FROM [stored procedure] ? 如何SELECT * INTO [temp table] FROM [stored procedure]进行SELECT * INTO [temp table] FROM [stored procedure] Not FROM [Table] and without defining [temp table] ? 不是FROM [Table] ,也没有定义[temp table]

Select all data from BusinessLine into tmpBusLine works fine. BusinessLine Select所有数据到tmpBusLine可以正常工作。

select *
into tmpBusLine
from BusinessLine

I am trying the same, but using a stored procedure that returns data, is not quite the same. 我正在尝试相同的方法,但是使用返回数据的stored procedure并不完全相同。

select *
into tmpBusLine
from
exec getBusinessLineHistory '16 Mar 2009'

Output message: 输出信息:

Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'exec'. 消息156,级别15,状态1,第2行关键字“ exec”附近的语法错误。

I have read several examples of creating a temporary table with the same structure as the output stored procedure, which works fine, but it would be nice to not supply any columns. 我已经阅读了几个创建与输出存储过程具有相同结构的临时表的示例,该示例工作正常,但是最好不要提供任何列。


解决方案:

参考一: https://stackoom.com/question/2k3m/将存储过程的结果插入临时表
参考二: https://oldbug.net/q/2k3m/Insert-results-of-a-stored-procedure-into-a-temporary-table

695856371Web网页设计师②群 | 喜欢本站的朋友可以收藏本站,或者加入我们大家一起来交流技术!

0条评论

Loading...


自定义皮肤 主体内容背景
打开支付宝扫码付款购买视频教程
遇到问题联系客服QQ:419400980
注册梁钟霖个人博客