USE [MuOnline]GO/****** Object: StoredProcedure [dbo].[WHS_UPD_Money] Script Date: 04/26/2018 08:44:41 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER proc [dbo].[WHS_UPD_Money]@mny int,@Accountid varchar(10)asset nocount ondeclare @cknum intSELECT @cknum=ExtCKNum FROM warehouse WHERE AccountID=@accountidif @cknum=0 --主仓库 UPDATE warehouse set Money=@mny where AccountID=@accountidelse UPDATE ExtWareHouse set Money=@mny where AccountID=@accountid AND Number=@cknum--waitfor delay '00:00:10'set nocount off