游标引起的疑问

问题描述

大家好

我对游标有疑问

我的程序是这样的

Hi all

I have a doubt regarding with cursor

my procedure is like this

set @fl1=1
set @fl2=41 
set @SB_Common1= 'where HR_EMP_REPORTING.BranchID =1'  
set @Month=5
set @Year=2011
set @mode='Salary'      
SET XACT_ABORT ON
BEGIN TRAN


IF @mode='Salary'
BEGIN
 
       DECLARE CUR_SALARY CURSOR FOR 
	Select HR_EMP_MASTER.Emp_Id,HR_EMP_MASTER.Emp_Code,HR_EMP_MASTER.First_Name from HR_EMP_MASTER INNER JOIN HR_EMP_REPORTING on HR_EMP_MASTER.Emp_Id=HR_EMP_REPORTING.emp_id <big>+ @SB_Common1</big>
    
		OPEN CUR_SALARY
		FETCH NEXT FROM CUR_SALARY INTO  @Emp_Id,@EmpCode,@EmployeeName

我的问题发生在我将"where"条件添加到选择语句中时.我想根据前端发生的选择添加where条件.但是当我添加如下所示的stsement错误时..

My problem happens when i add "where" condition to select statement .i want to add where condition according to the selection happening in front end.but when i adding where stsement error like below happening..

Msg 245, Level 16, State 1, Line 47
Conversion failed when converting the varchar value ''where HR_EMP_REPORTING.BranchID =1'' to data type int.

但是我想要根据选择的数据集..怎么做

在Advance中致谢

But i want dataset according to the selection ..how to do it

Thanks in Advance

推荐答案

这篇关于游标引起的疑问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！