Click here to Skip to main content
15,512,632 members
Home / Discussions / Database
   

Database

 
GeneralRe: Get columns name Pin
Victor Nijegorodov4-Jun-21 8:21
Victor Nijegorodov4-Jun-21 8:21 
GeneralRe: Get columns name Pin
Gerry Schmitz4-Jun-21 8:54
mveGerry Schmitz4-Jun-21 8:54 
GeneralRe: Get columns name Pin
Victor Nijegorodov4-Jun-21 9:02
Victor Nijegorodov4-Jun-21 9:02 
GeneralRe: Get columns name Pin
Gerry Schmitz4-Jun-21 10:01
mveGerry Schmitz4-Jun-21 10:01 
GeneralRe: Get columns name Pin
Victor Nijegorodov4-Jun-21 10:47
Victor Nijegorodov4-Jun-21 10:47 
AnswerRe: Get columns name Pin
Mycroft Holmes4-Jun-21 13:43
professionalMycroft Holmes4-Jun-21 13:43 
AnswerRe: Get columns name Pin
mverbeke31-Aug-21 4:59
mverbeke31-Aug-21 4:59 
SuggestionRe: Get columns name Pin
Richard Deeming31-Aug-21 5:50
mveRichard Deeming31-Aug-21 5:50 
I suggest you read the documentation:
Column IDs might not be sequential.
If a column has ever been dropped from the table, you will end up with gaps in the column ID sequence.

To get a true ordinal position, you'd need to use the ROW_NUMBER windowing function - for example:
SQL
SELECT [name], ROW_NUMBER() OVER (ORDER BY [column_id]) As [Ordinal]
FROM sys.columns
WHERE [object_id] = OBJECT_ID('MyTable')
ORDER BY [column_id]




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

QuestionSQL statements Pin
Erick Kaira27-May-21 9:09
Erick Kaira27-May-21 9:09 
AnswerRe: SQL statements Pin
Victor Nijegorodov27-May-21 9:40
Victor Nijegorodov27-May-21 9:40 
AnswerRe: SQL statements Pin
SeanChupas27-May-21 10:02
SeanChupas27-May-21 10:02 
QuestionRe: SQL statements Pin
David Crow27-May-21 10:12
David Crow27-May-21 10:12 
AnswerRe: SQL statements Pin
Mycroft Holmes27-May-21 13:19
professionalMycroft Holmes27-May-21 13:19 
QuestionSQL query dilemma Pin
David Crow20-May-21 11:31
David Crow20-May-21 11:31 
AnswerRe: SQL query dilemma Pin
Mycroft Holmes20-May-21 14:05
professionalMycroft Holmes20-May-21 14:05 
QuestionAccounting problem in SQL Pin
Member 1400680616-May-21 0:23
Member 1400680616-May-21 0:23 
AnswerRe: Accounting problem in SQL Pin
Mycroft Holmes16-May-21 13:17
professionalMycroft Holmes16-May-21 13:17 
AnswerRe: Accounting problem in SQL Pin
CHill6019-May-21 3:55
mveCHill6019-May-21 3:55 
QuestionSQL Server Execution Timeout Expired Pin
idkd13-May-21 0:00
idkd13-May-21 0:00 
AnswerRe: SQL Server Execution Timeout Expired Pin
SeanChupas13-May-21 2:49
SeanChupas13-May-21 2:49 
QuestionIn-memory database with acid transactions and high availability Pin
Mathieu Seillier12-May-21 3:54
Mathieu Seillier12-May-21 3:54 
AnswerRe: In-memory database with acid transactions and high availability Pin
Mycroft Holmes12-May-21 14:00
professionalMycroft Holmes12-May-21 14:00 
AnswerRe: In-memory database with acid transactions and high availability Pin
Richard MacCutchan12-May-21 22:08
mveRichard MacCutchan12-May-21 22:08 
AnswerRe: In-memory database with acid transactions and high availability Pin
Meysam Toluie29-Jan-22 0:06
Meysam Toluie29-Jan-22 0:06 
GeneralRe: In-memory database with acid transactions and high availability Pin
OriginalGriff29-Jan-22 0:08
mveOriginalGriff29-Jan-22 0:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.