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