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

Database

 
AnswerRe: Sql Server Pin
Eddy Vluggen5-Jun-15 9:25
professionalEddy Vluggen5-Jun-15 9:25 
AnswerRe: Sql Server Pin
Richard Deeming5-Jun-15 10:24
mveRichard Deeming5-Jun-15 10:24 
QuestionProvide large data updates to desktop users Pin
Kukreja Sonu3-Jun-15 1:53
Kukreja Sonu3-Jun-15 1:53 
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 
Since it's the same table you can just write it like this:
SQL
SELECT 
    Label
  , CONCAT(BFirstName, ' ',  BLastName) AS BAttention
  , BCity
FROM CardInfoPerm 
WHERE CardID = 1121

jkirkerx wrote:
not sure if it's safe
If you're thinking about null-values:
Quote:
Null values are implicitly converted to an empty string. If all the arguments are null, an empty string of type varchar(1) is returned.
(From https://msdn.microsoft.com/en-us/library/hh231515.aspx[^])

So you might want to surround the CONCAT(..) with a TRIM(..).
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

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

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.