团队存储过程

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
原文地址:https://www.cnblogs.com/l25321937/p/3192055.html