我已经编写了存储过程. 在查询分析器中执行代码 声明@amt float exec ReAlto``3'',``2010''@amt输出 选择@amt 上面的代码如何在VB.Net中执行 请发送代码.
I have written the store procedure. Execute the code in Query Analyzer Declare @amt float exec ReAlto ''3'',''2010'' @amt output Select @amt The Above code how can execute in VB.Net Plz send the code.
CREATE PROCEDURE ReAlto @MM varchar(50), @YY varchar(50), @amt float output AS Declare @Alto float Declare @DE_Alto float if(select sum(intAltoAmt) from tblJoiningPayment where strMonth<= @MM and strYear<= @YY)=0 Begin set @Alto=0 End else Begin select @Alto= sum(intAltoAmt) from tblJoiningPayment where strMonth<= @MM and strYear<= @YY End/***************************************************** ****************************************************** ****************************************************** ********/
/*************************************************************************************************************************************************************/
if(select sum(intPayAmount) from tblAltoPayment where strMonth<= @MM and strYear<= @YY)=0 Begin set @DE_Alto=0 End else Begin select @DE_Alto= sum(intPayAmount) from tblAltoPayment where strMonth<= @MM and strYear<= @YY End Begin Set @amt=( @Alto) - (@DE_Alto) End GO谢谢 Mahendra Kumar Das
Thanks Mahendra Kumar Das
推荐答案看看此处 [ ^ ]
更多推荐
如何获取值VB.net?
发布评论