Click here to Skip to main content
15,867,568 members
Home / Discussions / Database
   

Database

 
QuestionI'm trying to concat 2 columns into a single result Pin
jkirkerx2-Jun-15 10:12
professionaljkirkerx2-Jun-15 10:12 
GeneralRe: I'm trying to concat 2 columns into a single result Pin
jkirkerx2-Jun-15 10:13
professionaljkirkerx2-Jun-15 10:13 
AnswerRe: I'm trying to concat 2 columns into a single result Pin
Sascha Lefèvre2-Jun-15 10:43
professionalSascha Lefèvre2-Jun-15 10:43 
GeneralRe: I'm trying to concat 2 columns into a single result Pin
jkirkerx2-Jun-15 10:55
professionaljkirkerx2-Jun-15 10:55 
GeneralRe: I'm trying to concat 2 columns into a single result Pin
Sascha Lefèvre2-Jun-15 11:02
professionalSascha Lefèvre2-Jun-15 11:02 
QuestionRemoving the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf2-Jun-15 8:32
Stephen Holdorf2-Jun-15 8:32 
AnswerRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming2-Jun-15 22:20
mveRichard Deeming2-Jun-15 22:20 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 1:55
Stephen Holdorf3-Jun-15 1:55 
I don't understand what you mean. for instance take the code below:

query.Append("SELECT e581_key, 'e581', 'pickup_date', pickup_date , '" + _dateMaterialRequired + "' , 'SaveEditPickup', '" + _logUserName + "', getdate() ");

<pre>

Now _dateMaterialRequired and _timeMaterialRequired are variables, properties, that belong to the to the class that called the hard coded SQL statement. When the SQL is called how are the select statement return values assigned to the variables, properties, that are in the calling code?

GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 3:06
mveRichard Deeming3-Jun-15 3:06 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 3:13
Stephen Holdorf3-Jun-15 3:13 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 3:25
mveRichard Deeming3-Jun-15 3:25 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 3:32
Stephen Holdorf3-Jun-15 3:32 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 3:34
mveRichard Deeming3-Jun-15 3:34 
QuestionLDF file Size is so increased Pin
Azam Niaz Ch.31-May-15 23:30
Azam Niaz Ch.31-May-15 23:30 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter31-May-15 23:57
professionalKornfeld Eliyahu Peter31-May-15 23:57 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 0:07
Azam Niaz Ch.1-Jun-15 0:07 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 0:15
professionalKornfeld Eliyahu Peter1-Jun-15 0:15 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 0:26
Azam Niaz Ch.1-Jun-15 0:26 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 0:49
professionalKornfeld Eliyahu Peter1-Jun-15 0:49 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 1:29
Azam Niaz Ch.1-Jun-15 1:29 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 1:39
professionalKornfeld Eliyahu Peter1-Jun-15 1:39 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 1:50
Azam Niaz Ch.1-Jun-15 1:50 
AnswerRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 2:09
professionalKornfeld Eliyahu Peter1-Jun-15 2:09 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 2:17
Azam Niaz Ch.1-Jun-15 2:17 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 2:18
professionalKornfeld Eliyahu Peter1-Jun-15 2:18 

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.