USE [CHARACTER_01_DBF]
GO
/****** Objekt: StoredProcedure [dbo].[TAX_INFO_STR] Skriptdatum: 07/05/2010 14:57:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[TAX_INFO_STR]
@iGu char(2) = 'S1',
@serverindex char(2) = '01',
@nTimes int,
@nContinent int,
@dwID char(7),
@dwNextID char(7),
@bSetTaxRate int,
@change_time char(12)
as
set nocount on
if @iGu = 'S1'
begin
select isnull(max(nTimes), 0) as nTimes
from TAX_INFO_TBL
where serverindex = @serverindex
end
if @iGu = 'S2'
begin
select dwID, dwNextID, bSetTaxRate, change_time
from TAX_INFO_TBL
where serverindex = @serverindex and nTimes = @nTimes and nContinent = @nContinent
end
if @iGu = 'S3'
begin
select m_idPlayer
from GUILD_MEMBER_TBL
where serverindex = @serverindex and m_idGuild = right(@dwID, 6) and m_nMemberLv = 0
end
if @iGu = 'I1'
begin
insert into TAX_INFO_TBL (serverindex, nTimes, nContinent, dwID, dwNextID, change_time, bSetTaxRate)
select @serverindex, @nTimes, @nContinent, @dwID, @dwNextID, @change_time, @bSetTaxRate
end
if @iGu = 'U1'
begin
update TAX_INFO_TBL
set dwID = @dwID, dwNextID = @dwNextID, bSetTaxRate = @bSetTaxRate, save_time = getdate()
where serverindex = @serverindex and nTimes = @nTimes and nContinent = @nContinent
end
Alles anzeigen