Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. Salesforce
  3. Question
Salesforce

What's the easiest way to create a temp table in SQL Server that can hold the result of a stored procedure?

Asked by Carol Bower Apr 16, 2021 925 views 1 answer
Share

About this question

Many times I need to write something like the following when dealing with SQL Server.

create table #table_name ( column1 int, column2 varchar(200) ... ) insert into #table_name execute some_stored_procedure;But create a table which has the exact syntax as the result of a stored procedure is a tedious task. For example, the result of sp_helppublication has 48 columns! I want to know whether there is any easy way to do this. How sql server create temp table?

Your answer

1 Answer

More Salesforce discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest Salesforce Blogs

Guides, tips and career advice on Salesforce from JanBask experts.