Click here to Skip to main content
15,558,795 members
Home / Discussions / Database
   

Database

 
AnswerRe: Sql Server Pin
Eddy Vluggen5-Jun-15 10:25
professionalEddy Vluggen5-Jun-15 10:25 
AnswerRe: Sql Server Pin
Richard Deeming5-Jun-15 11:24
mveRichard Deeming5-Jun-15 11:24 
QuestionProvide large data updates to desktop users Pin
Kukreja Sonu3-Jun-15 2:53
Kukreja Sonu3-Jun-15 2:53 
AnswerRe: Provide large data updates to desktop users Pin
Mycroft Holmes3-Jun-15 15:42
professionalMycroft Holmes3-Jun-15 15:42 
AnswerRe: Provide large data updates to desktop users Pin
Mycroft Holmes3-Jun-15 20:51
professionalMycroft Holmes3-Jun-15 20:51 
QuestionI'm trying to concat 2 columns into a single result Pin
jkirkerx2-Jun-15 11:12
professionaljkirkerx2-Jun-15 11:12 
GeneralRe: I'm trying to concat 2 columns into a single result Pin
jkirkerx2-Jun-15 11:13
professionaljkirkerx2-Jun-15 11:13 
AnswerRe: I'm trying to concat 2 columns into a single result Pin
Sascha Lefèvre2-Jun-15 11:43
professionalSascha Lefèvre2-Jun-15 11: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 11:55
professionaljkirkerx2-Jun-15 11:55 
GeneralRe: I'm trying to concat 2 columns into a single result Pin
Sascha Lefèvre2-Jun-15 12:02
professionalSascha Lefèvre2-Jun-15 12:02 
QuestionRemoving the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf2-Jun-15 9:32
Stephen Holdorf2-Jun-15 9:32 
AnswerRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming2-Jun-15 23:20
mveRichard Deeming2-Jun-15 23:20 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 2:55
Stephen Holdorf3-Jun-15 2:55 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 4:06
mveRichard Deeming3-Jun-15 4:06 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 4:13
Stephen Holdorf3-Jun-15 4:13 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 4:25
mveRichard Deeming3-Jun-15 4:25 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Stephen Holdorf3-Jun-15 4:32
Stephen Holdorf3-Jun-15 4:32 
GeneralRe: Removing the concatenated code variable for a SQL select statement . Pin
Richard Deeming3-Jun-15 4:34
mveRichard Deeming3-Jun-15 4:34 
QuestionLDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 0:30
Azam Niaz Ch.1-Jun-15 0:30 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 0:57
professionalKornfeld Eliyahu Peter1-Jun-15 0:57 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 1:07
Azam Niaz Ch.1-Jun-15 1:07 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 1:15
professionalKornfeld Eliyahu Peter1-Jun-15 1:15 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 1:26
Azam Niaz Ch.1-Jun-15 1:26 
GeneralRe: LDF file Size is so increased Pin
Kornfeld Eliyahu Peter1-Jun-15 1:49
professionalKornfeld Eliyahu Peter1-Jun-15 1:49 
GeneralRe: LDF file Size is so increased Pin
Azam Niaz Ch.1-Jun-15 2:29
Azam Niaz Ch.1-Jun-15 2: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.