Posted By: znouza (- Armored Pilsener -) on 'CZdatabases'
Title:     Re: SQL ?
Date:      Wed Jun 21 09:57:24 2000

> 
>  Teda ja jsem taky jenom takovej amater, ale...
> 
> > No tohle resim tak ze team dam podminku typu 
> > 
> > select case when [date] is null then 0 end, * from tabulka where 
> > logfiledate<>cast(....) AND  [date]<>0
> 
>  Huh. Co to je ? To ma byt SQL ? Co to dela, to 0 end ?
>  Clovece, neblbni mi hlavu, zitra z toho delam zkousku ;-)

to je opravdu silenost 
a) jak chces do typu datetime cpat hodnotu 0
b) melo by to pak vypadat asi takhle
   select * from tabulka where isnull(date,'1900-01-01')<>logfiledate

> ... tak takhle bych to asi pojal
>                                                       Podlesh
>                                                    the lost whiner

     _  _    /--------                      znouza
   ( o)(o ) /__________
      ||        | |
      ||        |_|           "The game of life is hard to play..."
      **      __|                              3T 

Search the boards