yg kedua: biasa sech case ... when .. Then ... else ... end ga tau klu ada yg lbh simple.
oh yach .. yg pertama itu klu SQL embedd di PB ga bs lho .. plg biasa kita akalin pake SP --- mellon <[EMAIL PROTECTED]> wrote: > dear seniors PB, > > mau banyak tanya nih, mumpung libur 4 hari: > > pertanyaan pertama : > jika aku ingin format date 'yyyymmdd' memakai > database sql server bgm > caranya? > karena biasanya aku memakai database oracle9i & > PB6.5 > > ini contoh syntaxku jika memakai database oracle > select to_date(sysdate,'yyyymmdd) > from dual; > hasilnya 20060525 ( misal sekarang tanggal 25 mei > 2006 ) > > fungsi dual (jika di oracle) kalo di sql server apa? > > > pertanyaan kedua : > kalo aku ingin memakai fungsi jika dan hanya jika di > sql server bagaimana? > ini contoh syntax jika aku memakai database oracle9i > dan PB6.5 > select decode(job_title,'Supervisor', decode ( sex > ,'Male','OKE'),'TIDAK > OKE') > from emp_tabel ; > fungsi decode (jika dioracle) di sql server apa? > > thank b4 > Moko > > > __________________________________________________ > Apakah Anda Yahoo!? > Lelah menerima spam? Surat Yahoo! memiliki > perlindungan terbaik terhadap spam > http://id.mail.yahoo.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Protect your PC from spy ware with award winning anti spy technology. It's free. http://us.click.yahoo.com/97bhrC/LGxNAA/yQLSAA/NhFolB/TM --------------------------------------------------------------------~-> ----------------------------------------------- IndoPB - Indonesia PB User Group Learn PB6 by download FasTrack to PB6 at : http://groups.yahoo.com/group/indopb/files/Belajarpb6/ To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
