İsime Göre Tek Kodla Item Bulma | Query Analyzer

-- Item Bulma
SELECT *
FROM item
WHERE strname LIKE '%monster stone%'

-- NPC Kontrol
SELECT *
FROM K_NPC
WHERE sSid = 19999

-- Item Silme
DELETE
FROM item
WHERE num = 'itemnumarası'

-- Sınırsız Yapma
UPDATE magic
SET useitem = '0'
WHERE useitem = '389082000'

-- Sınırlı Yapma
UPDATE magic
SET useitem = '389020000'
WHERE magicnum = '490014'

-- DB'den DB'ye Tablo Aktarma
SELECT *
INTO KO_SERVER_001.dbo.K_MONSTER
FROM kn_online.dbo.K_MONSTER