Click here to Skip to main content
15,922,155 members
Home / Discussions / Database
   

Database

 
GeneralRe: MySQL and Images Pin
Paul Conrad24-Dec-07 16:44
professionalPaul Conrad24-Dec-07 16:44 
Generalconnecting to mssql 2005 express from vs2008 - RESOLVED Pin
l a u r e n22-Dec-07 21:06
l a u r e n22-Dec-07 21:06 
GeneralHelp in query design Pin
NetBot22-Dec-07 18:08
NetBot22-Dec-07 18:08 
GeneralRe: Help in query design Pin
Paul Conrad23-Dec-07 6:14
professionalPaul Conrad23-Dec-07 6:14 
GeneralTransfer records From Local To Host Pin
mehrdadc4822-Dec-07 9:01
mehrdadc4822-Dec-07 9:01 
GeneralRe: Transfer records From Local To Host Pin
DigiOz Multimedia22-Dec-07 11:49
DigiOz Multimedia22-Dec-07 11:49 
GeneralChecking Details to Display Pin
ShimnaMukundan21-Dec-07 18:46
ShimnaMukundan21-Dec-07 18:46 
GeneralRe: Checking Details to Display Pin
pmarfleet21-Dec-07 22:25
pmarfleet21-Dec-07 22:25 
You haven't stated what database you are using. However, if you are using SQL Server then you can use the COALESCE function. COALESCE returns the first non-null value in a series of values. It checks these values from l-r, so you can define an order of precedence. See the following example:

SELECT COALESCE([office], [cell], [residence]) AS Phone FROM MyTable


Hope this helps.
Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush


GeneralCheck box = Unchecked Pin
s3rro21-Dec-07 8:00
s3rro21-Dec-07 8:00 
GeneralRe: Check box = Unchecked Pin
pmarfleet21-Dec-07 9:07
pmarfleet21-Dec-07 9:07 
GeneralRe: Check box = Unchecked Pin
Dave Kreskowiak21-Dec-07 9:51
mveDave Kreskowiak21-Dec-07 9:51 
GeneralRe: Check box = Unchecked Pin
GuyThiebaut23-Dec-07 10:44
professionalGuyThiebaut23-Dec-07 10:44 
GeneralDeleteing From Table A When Records Not Found in Table B Pin
gunner_uk200021-Dec-07 3:26
gunner_uk200021-Dec-07 3:26 
GeneralRe: Deleteing From Table A When Records Not Found in Table B Pin
Michael Potter21-Dec-07 4:24
Michael Potter21-Dec-07 4:24 
QuestionInserting bulk data to SQL DB (SQL 2000) [modified] Pin
Daminda21-Dec-07 1:51
Daminda21-Dec-07 1:51 
GeneralRe: Inserting bulk data to SQL DB (SQL 2000) Pin
pmarfleet21-Dec-07 2:23
pmarfleet21-Dec-07 2:23 
GeneralRe: Inserting bulk data to SQL DB (SQL 2000) Pin
Paddy Boyd21-Dec-07 2:27
Paddy Boyd21-Dec-07 2:27 
GeneralCustom Auto Generated ID Pin
xavier198821-Dec-07 0:58
xavier198821-Dec-07 0:58 
GeneralRe: Custom Auto Generated ID Pin
pmarfleet21-Dec-07 2:21
pmarfleet21-Dec-07 2:21 
GeneralDatabas connection with java script Pin
rajesh4u20-Dec-07 22:48
rajesh4u20-Dec-07 22:48 
GeneralRe: Databas connection with java script Pin
Colin Angus Mackay21-Dec-07 0:12
Colin Angus Mackay21-Dec-07 0:12 
GeneralRe: Databas connection with java script Pin
NetBot22-Dec-07 18:26
NetBot22-Dec-07 18:26 
QuestionHow to avoid the alphabetic order of the columns returned when selected from a SQL linked server. Pin
kalam20-Dec-07 22:34
kalam20-Dec-07 22:34 
AnswerRe: How to avoid the alphabetic order of the columns returned when selected from a SQL linked server. Pin
Paddy Boyd21-Dec-07 1:03
Paddy Boyd21-Dec-07 1:03 
QuestionSql Server Login Pin
cbkulathunge20-Dec-07 20:05
cbkulathunge20-Dec-07 20:05 

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.