CREATE PROCEDURE [dbo].[Plan_DailyWorldSave] @world_id int, @gold bigint, @storage_gold bigint, @entry_date datetime as set nocount on set xact_abort on begin tran insert into Daily_World_Gold(world_id, gold, storage_gold, date) values(@world_id, @gold, @storage_gold, @entry_date) if(@@error <> 0) begin rollback return end commit