Using SQL Servers OPENROWSET to break the rules

  • Article

Many times I would like to insert the results of a stored procedure into a table so I can do some extra processing with the result set. I always have to create the table first in order to perform an Insert Into Exec on the desired stored procedure since Exec Into is not an option. Is there a way to do this without having to manually create the table each time?


4,696 reads


VMworld 2020 – Top 10 Database Sessions (Part 1)


Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 24 Sep 2020


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 SQL Server session preview


Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...

Read the latest Blogs


Creating a new branch in Git

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a new branch in...

Polybase and HA

By Admingod

I am planning for HA environment and we are using Polybase and would like...

Where do I start from ?

By Corobori

Following with a user complain about SQL timeout I bumped into one issue with...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers