CREATE PROCEDURE [dbo].[up_insert_cash_effectinfo]
			@item_id       		[uniqueidentifier],
			@character_id     	[uniqueidentifier],
			@package_code		int,
			@expire_time	 	int
			

as 
set nocount on
set xact_abort on

begin
	begin tran
		insert dbo.Cash_EffectTable
	    (
		[item_uid],	
		[cha_uid], 
		[package_code],
		[expire_time]
		)
		values( 
		@item_id, 
		@character_id, 
		@package_code,
		@expire_time
		)


	if(@@error <> 0 )
	begin
	     rollback
	     return

	end
	
	commit
end