代码改变世界

团队存储过程

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