Case Select (SQL)

Berikut adalah contoh query menggunakan case select :

select id,fullname,salary,overtime,
case
when salary <5000000 then 1.00*salary
when salary <10000000 then 0.5*salary
when salary >10000000 then 0.25*salary
end as bonus
from salary order by id

semoga bermanfaat...

Babasan/Paribahasa SUNDA

1. adam lali tapel = poho ka Baraya jeung poho ka Lemah cai.
2. adat kakurung ku iga = adat nu hese digantina.
3. aya bagja teu daulat = arek meunang bagja atawa kauntungan tapi teu tulus.
4. mun teu ngakal moal ngakeul =mun teu usaha moal pinanggih jeung rejeki pibekeleun hirup.
5. aku aku angga = ngaku barang batur kalawan ngandung maksud hayang mibanda - ngaku baraya batur anu beunghar atawa jeneng.
6. aki aki tujuh mulud = lalaki nu geus kolot pisan.
7. ambek nyedek tanaga midek = ari napsu pohara gedena, ngan tanaga euweuh.
8. eukeut ambeu seukeut deuleu = loba mata-matana jeung pinter nyusud perkara (keur pagawean pulisi).
9. nulungan anjing kadempet = nulungan jelema nu teu boga pisan rasa tumarima.
10.asa ditonjok congcot = meunang kabungah nu gede, anu saenyana teu diarep arep.
11.asa potong leungeun katuhu = leungiteun jalma nu pohara hade gawena.
12.nu asih dipulang sengit, nu haat dipulang moha = nu hade jeung loba jasana ka diri urang, dinyenyeri ku urang, ku omongan atawa ku kalakuan anu goreng.
13.ngagulkeun payung butut =ngagulkeun luluhur sorangan.
14.anak merak kukuncungan = sipat-sipat nu aya di anak, babakuna nu hadena, sasarina loba anu diturunkeun ku kolotna.
15.asa ditonjok congcot = meunang kabungah nu gede, anu saenyana teu diarep arep.

SQL Server (Log Database Terhapus)

/* Create a new database sama dengan database
yang tidak bisa diakses (contoh kasus "DBNAME") */

Jalankan script dibawah melalui T-SQL (database MASTER)

Create database
EXEC sp_configure 'allow updates', 1
RECONFIGURE WITH OVERRIDE
GO

BEGIN TRAN
UPDATE master..sysdatabases
SET status = status | 32768
WHERE name = 'DBNAME'

IF @@ROWCOUNT = 1
BEGIN
COMMIT TRAN
RAISERROR('emergency mode set', 0, 1)
END
ELSE
BEGIN
ROLLBACK
RAISERROR('unable to set emergency mode', 16, 1)
END
GO

1. Stop SQLserver
2. Replace DBNAME.mdf baru dengan DBNAME.mdf lama
3. Rename DBNAME.ldf baru menjadi DBNAMENew.ldf
4. Start SQLserver (status DBNAME emergency mode)
5. Run command
DBCC REBUILD_LOG('DBNAME','L:\DBNAME_log.LDF')

seharusnya keluar message

--Warning: The log for database 'DBNAME' has been rebuilt.
--Transactional consistency has been lost.

--DBCC CHECKDB should be run to validate physical consistency.
--Database options will have to be reset,
--and extra log files may need to be deleted.
--DBCC execution completed.
--If DBCC printed error messages,
--contact your system administrator.

6. Run data consistancy check (CHECHBD)
DBCC CHECKDB (DBNAME)
GO

7. Alter Database
ALTER DATABASE DBNAME SET MULTI_USER
GO

8. Update status database
EXEC sp_configure 'allow updates', 0
RECONFIGURE WITH OVERRIDE
GO