Click here to Skip to main content
14,971,029 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL Server 2010, smalldatetime insert Pin
Mycroft Holmes1-Jun-21 21:31
professionalMycroft Holmes1-Jun-21 21:31 
AnswerRe: SQL Server 2010, smalldatetime insert Pin
Victor Nijegorodov1-Jun-21 21:49
MemberVictor Nijegorodov1-Jun-21 21:49 
AnswerRe: SQL Server 2010, smalldatetime insert Pin
jkirkerx2-Jun-21 8:47
professionaljkirkerx2-Jun-21 8:47 
QuestionGet columns name Pin
_Flaviu27-May-21 23:55
Member_Flaviu27-May-21 23:55 
AnswerRe: Get columns name Pin
Victor Nijegorodov28-May-21 0:22
MemberVictor Nijegorodov28-May-21 0:22 
GeneralRe: Get columns name Pin
_Flaviu3-Jun-21 5:57
Member_Flaviu3-Jun-21 5:57 
GeneralRe: Get columns name Pin
Victor Nijegorodov3-Jun-21 20:13
MemberVictor Nijegorodov3-Jun-21 20:13 
GeneralRe: Get columns name Pin
_Flaviu3-Jun-21 20:37
Member_Flaviu3-Jun-21 20:37 
So, you are saying that I need to do a static analyze on SELECT text and see what columns I have, if I enumerate the columns in the SELECT statement, then I have it, if I don't (I have '*') then I have to query the tables names / columns name and will find them. I thought there is a SQL trick to find the columns name in any circumstances.
GeneralRe: Get columns name Pin
Victor Nijegorodov3-Jun-21 21:48
MemberVictor Nijegorodov3-Jun-21 21:48 
GeneralRe: Get columns name Pin
_Flaviu3-Jun-21 23:33
Member_Flaviu3-Jun-21 23:33 
GeneralRe: Get columns name Pin
Victor Nijegorodov4-Jun-21 0:55
MemberVictor Nijegorodov4-Jun-21 0:55 
AnswerRe: Get columns name Pin
Gerry Schmitz4-Jun-21 7:02
mveGerry Schmitz4-Jun-21 7:02 
GeneralRe: Get columns name Pin
Victor Nijegorodov4-Jun-21 7:21
MemberVictor Nijegorodov4-Jun-21 7:21 
GeneralRe: Get columns name Pin
Gerry Schmitz4-Jun-21 7:54
mveGerry Schmitz4-Jun-21 7:54 
GeneralRe: Get columns name Pin
Victor Nijegorodov4-Jun-21 8:02
MemberVictor Nijegorodov4-Jun-21 8:02 
GeneralRe: Get columns name Pin
Gerry Schmitz4-Jun-21 9:01
mveGerry Schmitz4-Jun-21 9:01 
GeneralRe: Get columns name Pin
Victor Nijegorodov4-Jun-21 9:47
MemberVictor Nijegorodov4-Jun-21 9:47 
AnswerRe: Get columns name Pin
Mycroft Holmes4-Jun-21 12:43
professionalMycroft Holmes4-Jun-21 12:43 
QuestionSQL statements Pin
Erick Kaira27-May-21 8:09
MemberErick Kaira27-May-21 8:09 
AnswerRe: SQL statements Pin
Victor Nijegorodov27-May-21 8:40
MemberVictor Nijegorodov27-May-21 8:40 
AnswerRe: SQL statements Pin
SeanChupas27-May-21 9:02
MemberSeanChupas27-May-21 9:02 
QuestionRe: SQL statements Pin
David Crow27-May-21 9:12
MemberDavid Crow27-May-21 9:12 
AnswerRe: SQL statements Pin
Mycroft Holmes27-May-21 12:19
professionalMycroft Holmes27-May-21 12:19 
QuestionSQL query dilemma Pin
David Crow20-May-21 10:31
MemberDavid Crow20-May-21 10:31 
AnswerRe: SQL query dilemma Pin
Mycroft Holmes20-May-21 13:05
professionalMycroft Holmes20-May-21 13:05 

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.