Click here to Skip to main content
15,900,461 members
Home / Discussions / Database
   

Database

 
GeneralRe: Stored procedures with booleans leading to different data types. Pin
D Hoffman17-Jan-12 1:35
D Hoffman17-Jan-12 1:35 
QuestionConverting from Access to MSDE 2000 Pin
Member 801739614-Dec-11 4:47
Member 801739614-Dec-11 4:47 
AnswerRe: Converting from Access to MSDE 2000 Pin
Corporal Agarn14-Dec-11 9:17
professionalCorporal Agarn14-Dec-11 9:17 
QuestionEquivalent in MS Sql Pin
Hum Dum13-Dec-11 22:51
Hum Dum13-Dec-11 22:51 
AnswerRe: Equivalent in MS Sql Pin
Geoff Williams14-Dec-11 0:17
Geoff Williams14-Dec-11 0:17 
AnswerRe: Equivalent in MS Sql Pin
Shameel14-Dec-11 2:28
professionalShameel14-Dec-11 2:28 
GeneralRe: Equivalent in MS Sql Pin
SilimSayo14-Dec-11 2:51
SilimSayo14-Dec-11 2:51 
GeneralRe: Equivalent in MS Sql Pin
jschell14-Dec-11 9:26
jschell14-Dec-11 9:26 
Shameel wrote:
In this case, CASE is an overkill and an IF statement
works perfectly well.


As a general statement I disgree with that.

The IF is an acceptable alternative if CASE didn't exist but CASE exists specifically to deal with situations exactly like that.

Given your statement what situation would be correct for CASE then?
GeneralRe: Equivalent in MS Sql Pin
Shameel15-Dec-11 7:27
professionalShameel15-Dec-11 7:27 
GeneralRe: Equivalent in MS Sql Pin
SilimSayo15-Dec-11 11:00
SilimSayo15-Dec-11 11:00 
GeneralRe: Equivalent in MS Sql Pin
jschell16-Dec-11 8:34
jschell16-Dec-11 8:34 
JokeRe: Equivalent in MS Sql Pin
SilimSayo16-Dec-11 14:31
SilimSayo16-Dec-11 14:31 
GeneralRe: Equivalent in MS Sql Pin
Shameel20-Dec-11 2:51
professionalShameel20-Dec-11 2:51 
QuestionGROUP BY and listing rows in an aggrigate Pin
nallelcm13-Dec-11 5:44
nallelcm13-Dec-11 5:44 
AnswerRe: GROUP BY and listing rows in an aggrigate Pin
Eddy Vluggen13-Dec-11 7:07
professionalEddy Vluggen13-Dec-11 7:07 
GeneralRe: GROUP BY and listing rows in an aggrigate Pin
nallelcm13-Dec-11 7:26
nallelcm13-Dec-11 7:26 
AnswerRe: GROUP BY and listing rows in an aggrigate Pin
Eddy Vluggen13-Dec-11 7:44
professionalEddy Vluggen13-Dec-11 7:44 
AnswerRe: GROUP BY and listing rows in an aggrigate Pin
Eddy Vluggen13-Dec-11 8:34
professionalEddy Vluggen13-Dec-11 8:34 
GeneralRe: GROUP BY and listing rows in an aggrigate Pin
nallelcm13-Dec-11 8:51
nallelcm13-Dec-11 8:51 
GeneralRe: GROUP BY and listing rows in an aggrigate Pin
Eddy Vluggen13-Dec-11 9:34
professionalEddy Vluggen13-Dec-11 9:34 
Questioncolums to single row Pin
Ramkumar_S12-Dec-11 18:29
Ramkumar_S12-Dec-11 18:29 
AnswerRe: colums to single row Pin
_Damian S_12-Dec-11 19:43
professional_Damian S_12-Dec-11 19:43 
AnswerRe: colums to single row Pin
SilimSayo13-Dec-11 3:13
SilimSayo13-Dec-11 3:13 
AnswerRe: colums to single row Pin
gvprabu22-Dec-11 1:45
gvprabu22-Dec-11 1:45 
Questionerror has occurred while establishing a connection Pin
Member 808991411-Dec-11 23:54
Member 808991411-Dec-11 23:54 

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.