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

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Read the latest Blogs

Forums

Get a Date Time Stamp of table when another columns value changes.

By lalitprg2017

I am having Below Table i want to get Result as shown in the...

how to write a query by using some filter patterns in SQL Server?

By maifs

what I want is to apply some filter patterns to search the data. For...

Tsql query to show currently running sql agent jobs

By vsamantha35

Hi All, Using Tsql query I want to know currently running sql agent jobs...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers