Click here to Skip to main content
15,868,419 members
Home / Discussions / Database
   

Database

 
QuestionMySQL:(urgent)Why reader.Close() hangs if a LONGBLOG field is selected? [modified] Pin
alesh_nitre9-Oct-07 20:50
alesh_nitre9-Oct-07 20:50 
QuestionColumn with Null value Pin
Mri1a9-Oct-07 20:28
Mri1a9-Oct-07 20:28 
AnswerRe: Column with Null value Pin
Mri1a9-Oct-07 20:40
Mri1a9-Oct-07 20:40 
AnswerRe: Column with Null value Pin
M LN Rao9-Oct-07 20:47
M LN Rao9-Oct-07 20:47 
AnswerRe: Column with Null value Pin
Paddy Boyd10-Oct-07 1:00
Paddy Boyd10-Oct-07 1:00 
QuestionThe maximum no. of Stored procedure in a database. Pin
Vipin.d9-Oct-07 19:54
Vipin.d9-Oct-07 19:54 
AnswerRe: The maximum no. of Stored procedure in a database. Pin
Paul Conrad3-Nov-07 7:52
professionalPaul Conrad3-Nov-07 7:52 
QuestionConcatenating Columns in query Pin
anujose9-Oct-07 19:05
anujose9-Oct-07 19:05 
Hi,

i am using sql server 2005 and i am writing one query to concatename 3 column values..
SELECT distinct(P.firstname + ' ' + P.middlename + ' ' + P.lastname) AS UserName ,P.Id as UserId,G.Id,G.Fkgroupid FROM c_Groupmember G,c_Person P where P.Id=G.FKUserid and G.FKgroupId=" + Id + " and P.Status=0 order by P.firstName asc


it will disply the username if first name and lastname is there .if there is only firstname .then i won't display any value?....

what is the solution for this ?.in query itself i need to get all the usernames.

with regards
anu
AnswerRe: Concatenating Columns in query Pin
M LN Rao9-Oct-07 20:51
M LN Rao9-Oct-07 20:51 
GeneralRe: Concatenating Columns in query Pin
anujose9-Oct-07 21:28
anujose9-Oct-07 21:28 
GeneralRe: Concatenating Columns in query Pin
anujose9-Oct-07 21:44
anujose9-Oct-07 21:44 
AnswerRe: Concatenating Columns in query Pin
Joe9-Oct-07 22:51
Joe9-Oct-07 22:51 
AnswerRe: Concatenating Columns in query Pin
pmpdesign11-Oct-07 18:18
pmpdesign11-Oct-07 18:18 
QuestionPreventing access to SQL Server from other Servers Pin
ben_6349-Oct-07 14:21
ben_6349-Oct-07 14:21 
AnswerRe: Preventing access to SQL Server from other Servers Pin
Christian Graus9-Oct-07 14:35
protectorChristian Graus9-Oct-07 14:35 
GeneralRe: Preventing access to SQL Server from other Servers Pin
ben_6349-Oct-07 15:41
ben_6349-Oct-07 15:41 
QuestionPerformance gain in SELECT ... Pin
devboycpp9-Oct-07 11:25
devboycpp9-Oct-07 11:25 
AnswerRe: Performance gain in SELECT ... Pin
Colin Angus Mackay9-Oct-07 12:30
Colin Angus Mackay9-Oct-07 12:30 
GeneralRe: Performance gain in SELECT ... Pin
devboycpp10-Oct-07 10:34
devboycpp10-Oct-07 10:34 
GeneralRe: Performance gain in SELECT ... Pin
Colin Angus Mackay10-Oct-07 11:18
Colin Angus Mackay10-Oct-07 11:18 
QuestionSQL2000 TempTable Pin
ss.mmm9-Oct-07 7:08
ss.mmm9-Oct-07 7:08 
AnswerRe: SQL2000 TempTable Pin
pmarfleet9-Oct-07 8:26
pmarfleet9-Oct-07 8:26 
QuestionI have a database is suspect Pin
Phan Van Thao9-Oct-07 5:50
Phan Van Thao9-Oct-07 5:50 
AnswerRe: I have a database is suspect Pin
Christian Graus9-Oct-07 14:37
protectorChristian Graus9-Oct-07 14:37 
QuestionHow to remove or rewrite author and log file information in summary of ssis package installation wizard? Pin
wang.z.y9-Oct-07 4:21
wang.z.y9-Oct-07 4:21 

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.