团队存储过程
2013-07-15 21:20 l25321937 阅读(192) 评论(0) 编辑 收藏 举报USE [MogoData355] GO /****** Object: StoredProcedure [dbo].[GetUserWithdrawDetailByWOID] Script Date: 07/02/2013 21:12:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[GetUserWithdrawDetailByWOID] @WOID int AS BEGIN select User_Withdraw_Detail.Amount, User_Financial.Contact, User_Withdraw_Detail.ID, User_Withdraw_Detail.LastModifyDate, User_Withdraw_Detail.RealityAmount, User_Withdraw_Detail.[Status] ,User_Withdraw_Detail.Tax, User_Withdraw_Detail.WFID, User_Withdraw_Detail.WOID from User_Withdraw_Detail inner join User_Financial on User_Financial.ID = User_Withdraw_Detail.WFID where User_Withdraw_Detail.WOID = @WOID END