OPENROWSET

External Article

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?

2008-08-14

4,696 reads

Blogs

Converting Types in C#

By

I am not a great software developer. I’m OK, and I do know how...

Daily Coping 22 Mar 2023

By

Today’s coping tip is to appreciate your hands and all the things they do...

FIRST Robotics Competition 2023 - World Championships!

By

On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...

Read the latest Blogs

Forums

Weird chars at beginning of XML file

By Jay@Work

Hi, each day we are sent an email with an XML attachment. Recently the...

Query based on sorting based on month

By Smash125

    SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...

SSRS 2017 - SSRS 2019 migration

By Wecks

I am after some advice, I have completed a SSRS migration 2017 - 2019. ...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers