75 lines
1 KiB
Transact-SQL
75 lines
1 KiB
Transact-SQL
CREATE procedure [dbo].[up_ado_data_mapping]
|
|
@bcust_id nvarchar(50),
|
|
@UUID uniqueidentifier,
|
|
@OnLine tinyint,
|
|
@ServerID smallint,
|
|
@ChannelID int,
|
|
@CharExp bigint,
|
|
@CharName nvarchar(16),
|
|
@IP nchar(16),
|
|
@fValue float,
|
|
@btValue tinyint,
|
|
@bGift bit,
|
|
@dDouble datetime,
|
|
@CharClass int
|
|
|
|
as
|
|
BEGIN
|
|
set nocount on
|
|
|
|
-- create table TTMapping (
|
|
-- @bcust_id nvarchar(50),
|
|
-- UUID uniqueidentifier,
|
|
-- OnLine tinyint,
|
|
-- ServerID smallint,
|
|
-- ChannelID int,
|
|
-- CharExp bigint,
|
|
-- CharName nvarchar(16),
|
|
-- IP nchar(16),
|
|
-- fValue float,
|
|
-- btValue tinyint,
|
|
-- bGift bit,
|
|
-- dDouble datetime,
|
|
-- CharClass int
|
|
-- )
|
|
|
|
INSERT INTO dbo.TTMapping (
|
|
|
|
windy_code,
|
|
UUID ,
|
|
OnLine ,
|
|
ServerID,
|
|
ChannelID,
|
|
CharExp ,
|
|
CharName,
|
|
IP ,
|
|
fValue ,
|
|
btValue ,
|
|
bGift ,
|
|
dDouble ,
|
|
CharClass
|
|
|
|
)
|
|
--
|
|
VALUES (
|
|
@bcust_id ,
|
|
@UUID ,
|
|
@OnLine ,
|
|
@ServerID ,
|
|
@ChannelID ,
|
|
@CharExp ,
|
|
@CharName ,
|
|
@IP ,
|
|
@fValue ,
|
|
@btValue ,
|
|
@bGift ,
|
|
@dDouble ,
|
|
@CharClass
|
|
--
|
|
)
|
|
|
|
select * from dbo.TTMapping
|
|
|
|
|
|
END
|
|
|