Click here to Skip to main content
15,506,846 members
Home / Discussions / Database
   

Database

 
AnswerRe: Get columns name Pin
Gerry Schmitz4-Jun-21 8:02
mveGerry Schmitz4-Jun-21 8:02 
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 
Try:

SELECT [name]. [column_id] AS [Ordinal]
FROM sys.columns
WHERE [object_id] = OBJECT_ID('MyTable')
ORDER BY [column_id];

That will get the column names and ordinal position.
SuggestionRe: Get columns name Pin
Richard Deeming31-Aug-21 5:50
mveRichard Deeming31-Aug-21 5:50 
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 

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.