alter Procedure [dbo].[P_poll_Get_checkpolluser] ( @user varchar(100), @Result int output ) AS Begin SELECT @Result=Count(*) from ( SELECT FCourseExeID from VDB_CoursRegisterAll where FUserName=@user and FMark >= FMinmark and FCourseExeID in(select FCourseExeID from [dbo].[TEvalSetting] where FISEnabled =1) EXCEPT SELECT FCourseExeID from [dbo].[TEvalScores] where FUserName=@user ) as k RETURN @Result end
using (Hrst context = new Hrst()) { ObjectParameter parameter = new ObjectParameter("Result", typeof(int?)); var q = context.P_poll_Get_checkpolluser(user, parameter).First(); if(Convert.ToInt32(parameter.Value.ToString()) > 0) {} }
RETURN @Result
SELECT @Result
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)