Click here to Skip to main content
15,919,358 members
Home / Discussions / Database
   

Database

 
GeneralRe: DateTime between two times Pin
Colin Angus Mackay11-May-05 3:15
Colin Angus Mackay11-May-05 3:15 
GeneralRe: DateTime between two times Pin
Michael P Butler11-May-05 3:26
Michael P Butler11-May-05 3:26 
GeneralRe: DateTime between two times Pin
Chris Meech11-May-05 9:20
Chris Meech11-May-05 9:20 
Generaldatabase Design Pin
imshally8110-May-05 23:59
imshally8110-May-05 23:59 
GeneralRe: database Design Pin
Anonymous11-May-05 0:22
Anonymous11-May-05 0:22 
GeneralRe: database Design Pin
hp10811-May-05 0:37
hp10811-May-05 0:37 
GeneralIF Statement with in Query Pin
si_6910-May-05 7:23
si_6910-May-05 7:23 
GeneralRe: IF Statement with in Query Pin
Filipe Peixinho10-May-05 7:58
Filipe Peixinho10-May-05 7:58 
Try the CASE statement.

e.g.

select school_id,class_id,
CASE school_id
WHEN 1 THEN left(class_id,1)
ELSE left(class_id,2)
as exp1
from student
where
exp1 = @class_val

I think this will work. Sorry but I can't test it now on my machine but try and let me know.

GeneralRe: IF Statement with in Query Pin
Member 195262810-May-05 15:03
Member 195262810-May-05 15:03 
GeneralNeed help on this query Pin
Filipe Peixinho10-May-05 6:10
Filipe Peixinho10-May-05 6:10 
GeneralRe: Need help on this query Pin
jasncab10-May-05 14:23
jasncab10-May-05 14:23 
GeneralOracleHelper Pin
Nizar Abdeljaoued10-May-05 5:30
Nizar Abdeljaoued10-May-05 5:30 
GeneralStock Update - Database Concurrency problem Pin
crowofatlantis10-May-05 1:54
crowofatlantis10-May-05 1:54 
GeneralTransact SQL Pin
Anonymous10-May-05 1:54
Anonymous10-May-05 1:54 
GeneralRe: Transact SQL Pin
Colin Angus Mackay10-May-05 3:37
Colin Angus Mackay10-May-05 3:37 
GeneralRe: Transact SQL Pin
Anonymous10-May-05 21:55
Anonymous10-May-05 21:55 
GeneralDatabase schema Pin
Member 1697710-May-05 0:15
Member 1697710-May-05 0:15 
GeneralRe: Database schema Pin
Colin Angus Mackay10-May-05 0:43
Colin Angus Mackay10-May-05 0:43 
GeneralRe: Database schema Pin
Member 1697710-May-05 2:08
Member 1697710-May-05 2:08 
GeneralADO.NET output parameter Pin
Timothy_19829-May-05 20:58
Timothy_19829-May-05 20:58 
GeneralRe: ADO.NET output parameter Pin
Colin Angus Mackay9-May-05 22:49
Colin Angus Mackay9-May-05 22:49 
GeneralRe: ADO.NET output parameter Pin
Timothy_198210-May-05 0:00
Timothy_198210-May-05 0:00 
GeneralRemote query being executed multiple times Pin
alex12059-May-05 20:32
alex12059-May-05 20:32 
GeneralProblem to search with a hyphen Pin
Nik_Pick9-May-05 10:16
Nik_Pick9-May-05 10:16 
Questionsql server 2000 documentor? Pin
WDI9-May-05 10:14
WDI9-May-05 10:14 

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.