CREATE TABLE [dbo].[KarakterBilgi] (
    [StrAccountID] [varchar] (21) NOT NULL ,
    [StrUserID] [varchar] (21) NOT NULL ,
    [StrPasswd] [varchar] (21) NOT NULL ,
    [Loyalty] [varchar] (21) NOT NULL ,
    [iDays] [varchar] (21) NOT NULL ,
    [Authority] [varchar] (21) NOT NULL 
) ON [PRIMARY]
GO

  CREATE PROCEDURE karakter_bilgi

@CharID  varchar(21)

as

-- Bu Script BoyuBeyi Tarafından Geliştirilmiştir...
-- Kodun Genel Amacı, Karekter Bilgisini Görüntülemektir...

truncate table karakterbilgi

Declare @StrAccountID varchar(21)
Declare @StrUserID varchar(21)
Declare @StrPasswd varchar(21)
Declare @Authority tinyint
Declare @Loyalty int
Declare @iDays tinyint

Select @StrAccountID = StrAccountID  from ACCOUNT_CHAR where StrCharID1 =    @CharID or StrCharID2 = @CharID or StrCharID3 = @CharID or StrCharID4  =   @CharID or StrCharID5 = @CharID

select  @StrUserID = StrUserID  from USERDATA where StrUserID = @CharID

select  @StrPasswd = StrPasswd , @iDays = iDays from TB_USER where StrAccountID = @strAccountID

select @Authority = Authority , @Loyalty = Loyalty from USERDATA where StrUserID = @CharID

Select StrAccountID , StrUserID , StrPasswd , Loyalty , iDays , Authority from karakterbilgi

insert into karakterbilgi values (@StrAccountID , @StrUserID , @StrPasswd , @Loyalty , @iDays , @Authority)

GO

EXEC karakter_bilgi 'CHARID'