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
------------------------ Yahoo! Groups Sponsor --------------------~-->
Everything you need is one click away. Make Yahoo! your home page now.
http://us.click.yahoo.com/AHchtC/4FxNAA/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/
