Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.
COURSE of the MONTH
15 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Select column_name from INFORMATION.SCHEMA.COLUMNS
Posted on 2016-10-07
I'm creating a global temp table using a random id and then trying to get column names from that table using INFORMATION_SCHEMA. Below is an example of what I'm doing --
SELECT 'JOHN' AS FIRST_NAME,'DAVIS' AS LAST_NAME ,'CHICAGO' AS CITY INTO [##E0404FF442A04AC7BCCEC33
select column_name from TEMPDB.INFORMATION_SCHEMA.
This does not work, it returns nothing under column_name. I can take that same table and copy it into another temp table, and it works.
SELECT * INTO ##OUT_LABEL FROM [##E0404FF442A04AC7BCCEC33
select column_name from TEMPDB.INFORMATION_SCHEMA.
column_name
FIRST_NAME
LAST_NAME
CITY
What am I missing here on why this is not working???
SELECT 'JOHN' AS FIRST_NAME,'DAVIS' AS LAST_NAME ,'CHICAGO' AS CITY INTO [##E0404FF442A04AC7BCCEC33
select column_name from TEMPDB.INFORMATION_SCHEMA.
This does not work, it returns nothing under column_name. I can take that same table and copy it into another temp table, and it works.
SELECT * INTO ##OUT_LABEL FROM [##E0404FF442A04AC7BCCEC33
select column_name from TEMPDB.INFORMATION_SCHEMA.
column_name
FIRST_NAME
LAST_NAME
CITY
What am I missing here on why this is not working???
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Active today
Try this ...
Brackets issue
select column_name from TEMPDB.INFORMATION_SCHEMA.
select column_name from TEMPDB.INFORMATION_SCHEMA.
Brackets issue
select column_name from TEMPDB.INFORMATION_SCHEMA.
select column_name from TEMPDB.INFORMATION_SCHEMA.
Active today
You should stop using INFORMATION_SCHEMA views. They have high overhead, including causing blocking. [Yes, I know that when you look at their view definition they look like they shouldn't have any extra overhead, but in actual practice they do.]
SELECT c.name AS column_name
FROM tempdb.sys.columns c
WHERE c.object_id = OBJECT_ID('tempdb.dbo.##E0
SELECT c.name AS column_name
FROM tempdb.sys.columns c
WHERE c.object_id = OBJECT_ID('tempdb.dbo.##E0
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…
Suggested Courses
Course of the Month15 days, 7 hours left to enroll
741 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.