Search the Community
Showing results for tags 'Mohon bantuan - soalan mudah'.
The search index is currently processing. Current results may not be complete.
Found 1 result
-
Salam untuk semua.. mohon bantuan,dah cuba tapi masih gagal.. contoh code : CREATE TABLE #temptable (id int,nm varchar(20),tarikh datetime); INSERT INTO #temptable VALUES (1001,'Hakim','2/12/2010'); SELECT * FROM #temptable; --DROP TABLE #temptable; soalan,macam mana saya nak compare fields 'tarikh' dengan 'gatedate()'? saya cuba macam ni,tapi gagal.. SELECT nm,tarikh= CASE tarikh WHEN tarikh <= getdate() THEN 'Aktif' ELSE 'Tidak Aktif' END FROM #temptable; Mohon bantuan.. Terima kasih.
