Some Query Codes For Beginners and Program

[mertek]

--Delete Banned Users From UserData
delete userdata where authority = '255'
------
--View Banned Users(0=Gm,1=Normal,2=Mute)
select * from userdata
where authority = '255'
------
--Write ip and find account info[View Account info]
Select * from tb_user
where ip = ' ip '
------
--Write Char and Find Account Info[View Account info]
declare @name varchar(21)
set @name = 'Write CharId'
SELECT * from ACCOUNT_CHAR
where struserid = @name
------
--Find Bronze Premium Users
Select * from tb_user
where premiumtype = '0'
------
--Clean currentuser
DeLeTe CuRReNTuSeR
--------
--Write Char id and show friends
select * from friend_list
where struserid = 'Please write char id here'
-------
--Delete Npc
delete from K_npc
where sSid = 'Write Npc sSid'
---------
--Delete Npc (Two and More)
DELETE FROM K_NPC
WHERE (sSid = Write Npc1 sSid) OR (sSid = Write NPC2 sSid)
---------
--Delete Monster
Delete from K_Monster
where sSid = 'Write Monster sSid'
---------
--Delete Monster (Two and More)
Delete From K_Monster
where (sSid = Write Monster1 sSid) or ( sSid = Write Monster2 sSid)
------------------------
and Some Query codes For Beginners Program:D
Download : http://trfuntr.tr.funpic.de/sqlcodes...20Beginner.exe
This Program have codes in here.i add some codes near for beginners.after i write middle class codes.Bad English :((
Update Button is Enabled! Enter Update and wait few seconds.(3-4 seconds wait)
-----------------------------------------
T

[ctgwglzc]

very big very strong for a beginner！