Click here to Skip to main content
15,861,168 members
Home / Discussions / Database
   

Database

 
AnswerRe: Provide large data updates to desktop users Pin
Mycroft Holmes3-Jun-15 14:42
professionalMycroft Holmes3-Jun-15 14:42 
AnswerRe: Provide large data updates to desktop users Pin
Mycroft Holmes3-Jun-15 19:51
professionalMycroft Holmes3-Jun-15 19:51 
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 
I know I should use a stored procedure to do this but ths is not possible. In the code below return values from the "select" statements are being assigned to code variable values being concatenated with the actual Select statement. I am not talking about the code in the Where clause but the code in the "Select" portion. See the string as below:

query.Append(" SELECT e581_key, 'e581', 'rnlt', rnlt, '" + _rnlt + "' , 'SaveEditRNLT', '" + _logUserName + "', getdate() ");
            query.Append(" FROM e581 ");            <pre>

The select statement is then assigned to the DbCommand.CommandText of the command.ExecuteNonQuery.

How do I move the actual code variables being concatenated to some type of command parameter?


modified 2-Jun-15 15:29pm.

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 
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 

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.