Insert in a temporal table the names of another table SQL Server 2008?

Say you have a known table create table known (sex char(1), age int, weight int, height int) This gives you the output required select id = ORDINAL_POSITION, NameColumn = COLUMN_NAME from INFORMATION_SCHEMA. COLUMNS where TABLE_NAME = 'known Output: id NameColumn ----------- ----------- 1 sex 2 age 3 weight 4 height If you wanted to create a table out of it, something like select id = ORDINAL_POSITION, NameColumn = COLUMN_NAME into #temporal from INFORMATION_SCHEMA. COLUMNS where TABLE_NAME = 'known.

Say you have a known table create table known (sex char(1), age int, weight int, height int) This gives you the output required select id = ORDINAL_POSITION, NameColumn = COLUMN_NAME from INFORMATION_SCHEMA. COLUMNS where TABLE_NAME = 'known' Output: id NameColumn ----------- ----------- 1 sex 2 age 3 weight 4 height If you wanted to create a table out of it, something like select id = ORDINAL_POSITION, NameColumn = COLUMN_NAME into #temporal from INFORMATION_SCHEMA. COLUMNS where TABLE_NAME = 'known.

Cool, I`m trying it, thanks – cMinor Feb 16 at 19:52.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions